Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you attach some sample data?
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)
Thank you qlikviewwizard but it worked now
yes it worked
thank you very much