Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator II
Creator II

Pick match statement without creating an extra expression

Dear Qlik user

I have a pick match statement which counts a number of patients by a category based on a button selection

I.e. Pick(Match(v_selected1,2,3),$(Count_Day), $(Count_Emerg), $(Count_IP)))

I would like to know whether it is possible to use a second field to show the number of patients who died from filed IP_Discharge_Method without having to rewrite my expressions

I.e. If(IP_Discharge_Method=Died(Pick(Match(v_selected1,2,3),$(Count_Day), $(Count_Emerg), $(Count_IP)))


Any help would be greatly appreciated


Kind Regards

Helen

2 Replies
pradosh_thakur
Master II
Master II

More info on the requirement please.

Learning never stops.
marcus_sommer
MVP & Luminary
MVP & Luminary

I assume that your variables within the pick-part are expressions. And there you could add something like:

... IP_Discharge_Method = {'Died'} ...


to apply this condition or maybe:


... IP_Discharge_Method = p(IP_Discharge_Method) ...


to be more flexible and just select which values should be included within the condition.


- Marcus