Qlikview set analysis with multiple conditions

qlikview
user3264602 picture user3264602 · Jul 11, 2014 · Viewed 10.2k times · Source

I have the following set analysis with one condition.

=sum({1} bank_shr_bal)/1000000

I need to create a second condition that filters the months the data collects from. The date column needs to be greater than a variable created called "minusYear" and the dimension I'm comparing it to is called MonthEnd. I'm really not sure how to do a greater than with Qlikview set analysis.

Thank you in advance for the help.

Answer

bdiamante picture bdiamante · Jul 12, 2014

You can use the <> set modifier syntax with your MonthEnd field. It would look like this:

=sum({1<MonthEnd=">$(minusYear)">}bank_shr_bal)/1000000

The set you are are looking at is the entire universe because you used the 1 as your set identifier. Then the modifier <MonthEnd=">$(minusYear)"> restricts the the set to only those values meeting the condition defined for MonthEnd. The " is used for expressions in QV so we can write the expression > $(minusYear) between the quotes and the expression will get resolved.

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