topic Re: Aggregation with Multiple If Conditions in QlikView

Aggregation with Multiple If Conditions

danyal1990 — Sat, 16 Nov 2024 00:14:44 GMT

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)

Re: Aggregation with Multiple If Conditions

danyal1990 — Wed, 29 Jul 2020 01:13:57 GMT

Please help guys!

Re: Aggregation with Multiple If Conditions

Brett_Bleess — Tue, 11 Aug 2020 19:00:19 GMT

It would be very helpful if you attach your QVW file on this one so folks can look at the data model in addition to the properties of the objects too. If you have sensitive information, you can use Settings\Document Properties\Scrambling tab to protect those prior to posting the file.

Regards,
Brett