topic Re: Pick and Match on multiple columns not working for below code in QlikView

Pick and Match on multiple columns not working for below code

hrithikroshan — Wed, 25 Nov 2020 16:16:04 GMT

LOAD
[Risk Impact],
[Risk Likelihood],
pick(Match(
([Risk Impact]= 1 and [Risk Likelihood] =1),
[Risk Impact] = 1 AND [Risk Likelihood] =2),'low','high') as calc
FROM
[D:\Risks.qvd]
(qvd);

i am not getting the expected output kindly see the attachment, if risk impact and likelihood is 1 then i should get low and if risk impact is 1 and likelihood is 2 then i should get high but i am getting wrong results kindly suggest what i am doing mistake in this code

Re: Pick and Match on multiple columns not working for below code

Taoufiq_Zarra — Sun, 01 Dec 2019 20:43:35 GMT

Hi,

'Pick', I don't think it's being used in its role if I understood your need correctly.

try this simple formula in the script:

if(([RISKIMPACT]= 1 and [RISKLiKELIHOUD] =1) or ([RISKIMPACT]= 1 and [RISKLiKELIHOUD] =2),'low','high') as NEW_CALC

I think that's the expected result.

Regards,

Taoufiq

Re: Pick and Match on multiple columns not working for below code

hrithikroshan — Mon, 02 Dec 2019 06:54:22 GMT

I am using lot of If conditions in my logic and i need to replace multiple if's with pick and match .

for sample purpose i just mentioned only few if conditions

i need to use pick and match only for this requirement

Re: Pick and Match on multiple columns not working for below code

tresB — Mon, 02 Dec 2019 07:46:15 GMT

Try like:

pick(Match( -1,
([Risk Impact]= 1 and [Risk Likelihood] =1),
[Risk Impact] = 1 AND [Risk Likelihood] =2),'low','high') as calc

Re: Pick and Match on multiple columns not working for below code

hrithikroshan — Mon, 02 Dec 2019 08:55:18 GMT

Perfect answer thanks for your kind time