How to make dynamic condition set analysis correctly ?

[wallacechen]

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