Aggregation with Multiple If Conditions

[danyal1990]

Dear All,

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.

Can you please help me out where i am making mistake?

=if(count(if(Store_category='Supermarket' and Parameter='KPI-1' and [KPI Compliance]='C', Category))>=3,1,
count(if(Store_category='Pharmacy' and Parameter='KPI-1' and [KPI Compliance]='C', Category))>=4,1,0)

[Brett_Bleess]

See duplicate post: https://community.qlik.com/t5/QlikView-Scripting/Aggregation-with-Multiple-If-Conditions/m-p/1731229...

Regards,
Brett