QlikView:Using dimensions value in expression

qlikview
Salik picture Salik · Nov 27, 2013 · Viewed 10.8k times · Source

I am trying to figure out how can I use dimension values as one of the set modifiers in Expressions in qlikview. Consider the following:

Raw Data:
PName, count
AB,2
BC,3
CD,4

Dimension:
Name

Expression:
SUM(<{PName=Name}>count)

i-e using the dimension value as one of the set modifiers.

Thanks

Answer

smartmeta picture smartmeta · Nov 28, 2013

As @bdiamante said. It is not clear what you exactly want to do.

But I assume that you only want to use the current value of the dimension to calculate the count of names. If that is true, then you can simply say:

Expression:
=sum(count)

HTH

Related questions

Counting unique values in a column in pandas dataframe like in Qlik?

If I have a table like this: df = pd.DataFrame({ 'hID': [101, 102, 103, 101, 102, 104, 105, 101], 'dID': [10, 11, 12, 10, 11, 10, 12, 10], 'uID': ['James', 'Henry', 'Abe', 'James', 'Henry', 'Brian', 'Claude', 'James'], 'mID': ['A', 'B', 'A', 'B', 'A', 'A', 'A', 'C'] }) I can do count(distinct hID) in Qlik to come …

Read More
Limit dimension values displayed in QlikView Pivot Table Chart

I have a pivot table chart in QlikView that has a dimension and an expression. The dimension is a column with 5 possible values: 'a','b','c','d','e'. Is there a way to restrict the values to 'a','b' and …

Read More
QlikView - Use a variable into set analysis expression

I've the variable varCurrentYear varCurrentYear = Year(Today()) And I wrote this set analysis expression The result it’s not correct. By the way If the variable is declared in this way varCurrentYear = 2014 The result is correct. Why? Thank's

Read More