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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
danyal1990
Contributor II
Contributor II
‎2020-07-28 05:16 AM

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)
Labels
648 Views
0 Likes
1 Reply
Brett_Bleess
Former Employee
Former Employee
‎2020-08-11 03:09 PM

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.
586 Views
0 Likes