Dinamyc selection on a filter in Qlik Sense

[ckoltam]

Hi,

I want to know if is possible to use set analysis on a filter in Qlik Sense to make the default filters dynamic.

[RafaelBarrios · Accepted solution]

hi @ckoltam 

Yes, but you will need to combine the set expression with a aggr in other to get a list from the result

for example:

=date(aggr(only({< dv_year={2022},dv_month={'Jan'} >}dv_date),dv_date))

for a full two year date field, i will get a filter for only January 2022

another example:

https://community.qlik.com/t5/New-to-Qlik-Sense/Aggr-in-filter-pane/td-p/95563

Best,

[ckoltam]

Thank you @RafaelBarrios ! The link is very helpful.