Sum of criteria grouped by multiple criterias

[Anonymous]

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

[qlikviewwizard]

Hi mustafa.hasan

Can you attach some sample data?

[pooja_prabhu_n]

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]

Thank you qlikviewwizard‌ but it worked now

[Anonymous]

yes it worked

thank you very much