Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
danyal1990
Contributor II
Contributor II

Aggregation with Multiple If Conditions

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)

 

 

Qlik Issue.jpg

Labels (1)
1 Reply
Brett_Bleess
Former Employee
Former Employee

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.