topic How to make dynamic condition set analysis correctly ? in QlikView https://community.qlik.com/t5/QlikView/How-to-make-dynamic-condition-set-analysis-correctly/m-p/104269#M16443 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>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 ? </P><P></P><P>=aggr(count({&lt;<STRONG>KPI</STRONG>={"&gt;=$(=$(Vmaimin))&lt;=$(=$(Vmaimax))"},Province={'Riau'}&gt;+&lt;<STRONG>KPI</STRONG>={"&gt;=$(=$(Vmaimin))&lt;=$(=$(Vmaimax))"}.....</P><P></P><P></P><P>script in load script for let variables : </P><P></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">KPIselect:<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">LOAD</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> * </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">inline</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[<BR /> KPIselect, select<BR /> KPI1,'speaking'<BR /> KPI2,'listening'<BR /> <BR /> ]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">; <BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">Let</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> KPIselect2='=GetFieldSelections(KPIselect)';</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Thanks <BR /></SPAN></P></BODY></HTML> Tue, 03 Jul 2018 09:56:52 GMT wallacechen 2018-07-03T09:56:52Z How to make dynamic condition set analysis correctly ? https://community.qlik.com/t5/QlikView/How-to-make-dynamic-condition-set-analysis-correctly/m-p/104269#M16443 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>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 ? </P><P></P><P>=aggr(count({&lt;<STRONG>KPI</STRONG>={"&gt;=$(=$(Vmaimin))&lt;=$(=$(Vmaimax))"},Province={'Riau'}&gt;+&lt;<STRONG>KPI</STRONG>={"&gt;=$(=$(Vmaimin))&lt;=$(=$(Vmaimax))"}.....</P><P></P><P></P><P>script in load script for let variables : </P><P></P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">KPIselect:<BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">LOAD</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> * </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">inline</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">[<BR /> KPIselect, select<BR /> KPI1,'speaking'<BR /> KPI2,'listening'<BR /> <BR /> ]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">; <BR /> </SPAN><STRONG style="color: blue; font-size: 9.0pt; font-family: 'Courier New';">Let</STRONG><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> KPIselect2='=GetFieldSelections(KPIselect)';</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><BR /></SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Thanks <BR /></SPAN></P></BODY></HTML> Tue, 03 Jul 2018 09:56:52 GMT https://community.qlik.com/t5/QlikView/How-to-make-dynamic-condition-set-analysis-correctly/m-p/104269#M16443 wallacechen 2018-07-03T09:56:52Z