Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
AmitSah
Contributor II
Contributor II

How to use Aggr function and Variable input to limit the Dimension

Hi Experts,

I am new to Qlik Sense and trying to understand some functionalities.

I am trying to limit the dimension using some expression which is going to derive on the basis of Variable selection. i.e in the below screenshot if I select "Select ALL" from Recency then the below Customers table should filter on the basis that the Transaction date should be <=2017/12/31 and for which I have created a variable (vRecencyConditional) which will calculate that date on the basis of selection from that dropdown. There are 4 elements created for that dropdown and on the basis of selection different date range will be there.

When I am selecting "Select All" and "above 90 days" from the selector then it is working fine but not for the other 2 selections.

My Limit condition is as below:

=aggr(only({$<Date_Derived={"$(=$(vRecencyConditional))"}>}Mobile)
,Mobile,Store_Name,Date_Derived)

Aggr to limit dimension.PNG

 

Could you please help me with getting the expression in the right direction. I have also attached a QVF file for the same.

Any help will be appreciated. 

Thanks,

Amit

0 Replies