https://community.qlik.com/t5/App-Development/KPI-Calculation-having-variable-with-nested-aggregation/m-p/1768933#M59477 <P>I have a measure Update Score ( Values&nbsp; : 1, 2,3 )</P><P>Update score is calculated by range comparison in if then else i.e</P><P>update score = [ if avg( min a + min b ) between 2 and 5 then 1 else so on ]</P><P>In KPI caluculation :&nbsp;</P><P>=count({&lt;'$V_Update_score'={'3'}&gt;}([Test ID]))&nbsp; &nbsp; to count test_ids where update_score = 3&nbsp;</P><P>This expression is not taking where clause in set analysis and returning just the total ids.</P><P>Please suggest.</P><P>&nbsp;</P> Sat, 16 Nov 2024 17:41:54 GMT shrutipg 2024-11-16T17:41:54Z https://community.qlik.com/t5/App-Development/KPI-Calculation-having-variable-with-nested-aggregation/m-p/1768933#M59477 <P>I have a measure Update Score ( Values&nbsp; : 1, 2,3 )</P><P>Update score is calculated by range comparison in if then else i.e</P><P>update score = [ if avg( min a + min b ) between 2 and 5 then 1 else so on ]</P><P>In KPI caluculation :&nbsp;</P><P>=count({&lt;'$V_Update_score'={'3'}&gt;}([Test ID]))&nbsp; &nbsp; to count test_ids where update_score = 3&nbsp;</P><P>This expression is not taking where clause in set analysis and returning just the total ids.</P><P>Please suggest.</P><P>&nbsp;</P> Sat, 16 Nov 2024 17:41:54 GMT https://community.qlik.com/t5/App-Development/KPI-Calculation-having-variable-with-nested-aggregation/m-p/1768933#M59477 shrutipg 2024-11-16T17:41:54Z https://community.qlik.com/t5/App-Development/KPI-Calculation-having-variable-with-nested-aggregation/m-p/1769245#M59490 <P>Hi, sorry for my english,</P><P>Maybe this help you</P><P><SPAN>=count({&lt;[Test ID]={"=$(V_Update_score)=3"}&gt;} [Test ID] )</SPAN></P> Thu, 17 Dec 2020 12:44:30 GMT https://community.qlik.com/t5/App-Development/KPI-Calculation-having-variable-with-nested-aggregation/m-p/1769245#M59490 TiagoCardoso 2020-12-17T12:44:30Z