topic Re: Pick match statement without creating an extra expression in QlikView

Pick match statement without creating an extra expression

helen_pip — Tue, 21 Aug 2018 10:15:28 GMT

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

Re: Pick match statement without creating an extra expression

pradosh_thakur — Tue, 21 Aug 2018 10:43:17 GMT

More info on the requirement please.

Re: Pick match statement without creating an extra expression

marcus_sommer — Tue, 21 Aug 2018 12:32:17 GMT

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