https://community.qlik.com/t5/QlikView/Aggregation-with-Multiple-If-Conditions/m-p/1734971#M455481 <P>See duplicate post:&nbsp;<A href="https://community.qlik.com/t5/QlikView-Scripting/Aggregation-with-Multiple-If-Conditions/m-p/1731229#M99626" target="_blank">https://community.qlik.com/t5/QlikView-Scripting/Aggregation-with-Multiple-If-Conditions/m-p/1731229#M99626</A></P><P>Regards,<BR />Brett</P> Tue, 11 Aug 2020 19:09:21 GMT Brett_Bleess 2020-08-11T19:09:21Z https://community.qlik.com/t5/QlikView/Aggregation-with-Multiple-If-Conditions/m-p/1731284#M455480 <P>Dear All,</P><P>I am writing an expression to calculate if the store is how many times compliant in that specif KPI and then sum those all occurrences to make it an overall result. But i am stuck in if conditions and it is not working as expected.</P><P>&nbsp;</P><P>Can you please help me out where i am making mistake?</P><P>=<FONT color="#0000FF">if</FONT>(<FONT color="#0000FF">count</FONT>(<FONT color="#0000FF">if</FONT>(<FONT color="#800000">Store_category</FONT>='Supermarket'<SPAN>&nbsp;</SPAN><FONT color="#0000FF">and</FONT><SPAN>&nbsp;</SPAN><FONT color="#800000">Parameter</FONT>='KPI-1'<SPAN>&nbsp;</SPAN><FONT color="#0000FF">and</FONT><SPAN>&nbsp;</SPAN><FONT color="#800000">[KPI Compliance]</FONT>='C',<SPAN>&nbsp;</SPAN><FONT color="#800000">Category</FONT>))&gt;=3,1,<BR /><FONT color="#0000FF">count</FONT>(<FONT color="#0000FF">if</FONT>(<FONT color="#800000">Store_category</FONT>='Pharmacy'<SPAN>&nbsp;</SPAN><FONT color="#0000FF">and</FONT><SPAN>&nbsp;</SPAN><FONT color="#800000">Parameter</FONT>='KPI-1'<SPAN>&nbsp;</SPAN><FONT color="#0000FF">and</FONT><SPAN>&nbsp;</SPAN><FONT color="#800000">[KPI Compliance]</FONT>='C',<SPAN>&nbsp;</SPAN><FONT color="#800000">Category</FONT>))&gt;=4,1,0)</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-right" image-alt="Qlik Issue.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/38161i985F40D8737079D3/image-size/large?v=v2&amp;px=999" role="button" title="Qlik Issue.jpg" alt="Qlik Issue.jpg" /></span></P> Sat, 16 Nov 2024 00:14:25 GMT https://community.qlik.com/t5/QlikView/Aggregation-with-Multiple-If-Conditions/m-p/1731284#M455480 danyal1990 2024-11-16T00:14:25Z https://community.qlik.com/t5/QlikView/Aggregation-with-Multiple-If-Conditions/m-p/1734971#M455481 <P>See duplicate post:&nbsp;<A href="https://community.qlik.com/t5/QlikView-Scripting/Aggregation-with-Multiple-If-Conditions/m-p/1731229#M99626" target="_blank">https://community.qlik.com/t5/QlikView-Scripting/Aggregation-with-Multiple-If-Conditions/m-p/1731229#M99626</A></P><P>Regards,<BR />Brett</P> Tue, 11 Aug 2020 19:09:21 GMT https://community.qlik.com/t5/QlikView/Aggregation-with-Multiple-If-Conditions/m-p/1734971#M455481 Brett_Bleess 2020-08-11T19:09:21Z