Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
wallacechen
Creator
Creator

How to make dynamic condition set analysis correctly ?

Hi ,

How to use let variables correctly to replace KPI in the expression to call different KPIs when selecting the KPI you want to filter showing up in qlikview dashboard table ?

=aggr(count({<KPI={">=$(=$(Vmaimin))<=$(=$(Vmaimax))"},Province={'Riau'}>+<KPI={">=$(=$(Vmaimin))<=$(=$(Vmaimax))"}.....

script in load script for let variables :

KPIselect:
LOAD * inline [
KPIselect, select
KPI1,'speaking'
KPI2,'listening'

]
;
Let KPIselect2='=GetFieldSelections(KPIselect)';


Thanks

0 Replies