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

AmitSah — Sat, 16 Nov 2024 19:05:43 GMT

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)

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

topic How to use Aggr function and Variable input to limit the Dimension in App Development

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