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
