Pick match statement without creating an extra expression

[helen_pip]

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

[pradosh_thakur]

More info on the requirement please.

[marcus_sommer]

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