Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

wallacechen
Contributor

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