Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum of criteria grouped by multiple criterias

I have to show in a dashboard the number of Claims and the number of transactions that are grouped by the response type of the claims i used the below script and it worked fine to show the number of transactions.

=if(([CLAIMRESPONSETYPE-ResponseTypeID]=1),'Automatic Response',if(([CLAIMRESPONSETYPE-ResponseTypeID]=2),'Automatic Response',if(([CLAIMRESPONSETYPE-ResponseTypeID]=3),'Automatic Response',if(([CLAIMRESPONSETYPE-ResponseTypeID]=4),'Automatic Response',if(([CLAIMRESPONSETYPE-ResponseTypeID]=5),'AR But Manual Response',if(([CLAIMRESPONSETYPE-ResponseTypeID]=6),'AR But Manual Response',if(([CLAIMRESPONSETYPE-ResponseTypeID]=7),'Manual Response',[ResponseType])))))))

But also i have to show by default the month the has the max number of transactions

4 Replies
qlikviewwizard
Master II
Master II

Hi mustafa.hasan

Can you attach some sample data?

pooja_prabhu_n
Creator III
Creator III

Hi,

You can try like below

if(([CLAIMRESPONSETYPE-ResponseTypeID]=1 and Month= vMaxMonth),'Automatic Response')

or


if([CLAIMRESPONSETYPE-ResponseTypeID]=1 ,Only({<Month={"$(vMaxMonth)"}>}Automatic Response)



Anonymous
Not applicable
Author

Thank you qlikviewwizard‌ but it worked now

Anonymous
Not applicable
Author

yes it worked

thank you very much