topic Re: Multiple IF, PICK AND MATCH in QlikView

Multiple IF, PICK AND MATCH

infock12 — Thu, 13 Aug 2015 15:45:52 GMT

Hello all,

I have a load script that I used to change the text in a field to a different text based on the Question number. This says that if the value of QuestionNumber 25 is 'Yes', change it to ;No' and vice versa.

IF(Match(QuestionNumber, 25), Pick(Match(CResponse,'Yes','No', CResponse),'No','Yes', CResponse) as Response;

How do I add another IF statement to say for QuestionNumber 26, if there is a 'No' response say 'Yes', but if there is a 'Yes' response, leave it as 'Yes'

I tried the below but it didn't work.

IF(Match(QuestionNumber, 25), Pick(Match(CResponse,'Yes','No', CResponse),'No','Yes', CResponse) AND IF(Match(QuestionNumber, 26), Pick(Match(CResponse,'No', CResponse), 'Yes', CResponse) as Response;

I tried connecting two IF statements with a comma instead of 'AND' but that did not work either.

Any help is appreciated!

Re: Multiple IF, PICK AND MATCH

maxgro — Thu, 13 Aug 2015 15:50:01 GMT

IF(Match(QuestionNumber, 25), Pick(Match(CResponse,'Yes','No', CResponse),'No','Yes', CResponse),

IF(Match(QuestionNumber, 26), Pick(Match(CResponse,'Yes','No', CResponse),'Yes','Yes', CResponse),

'no 25 or 26'

))

as Response

Re: Multiple IF, PICK AND MATCH

Qrishna — Thu, 13 Aug 2015 15:55:55 GMT

Not sure, if you need this.

Re: Multiple IF, PICK AND MATCH

sunny_talwar — Thu, 13 Aug 2015 15:56:47 GMT

This may be:

IF(Match(QuestionNumber, 25), Pick(Match(CResponse,'Yes', 'No', CResponse),'No','Yes', CResponse), IF(Match(QuestionNumber, 26), Pick(Match(CResponse,'No', CResponse), 'Yes', CResponse), CResponse)) as Response;

Re: Multiple IF, PICK AND MATCH

infock12 — Thu, 13 Aug 2015 16:09:00 GMT

Thanks Massimo! However, it gives the value as 'no 25 or 26' for the whole column. I think it is because we are saying 'no 25 or 26' before the double brackets in the end.

I tried:

IF(Match(QuestionNumber, 25), Pick(Match(CResponse,'Yes','No', CResponse),'No','Yes', CResponse),

IF(Match(QuestionNumber, 26), Pick(Match(CResponse,'Yes','No', CResponse),'Yes','Yes', CResponse),

CResponse)) as Response;

and this worked!!

Thanks for your help.

Re: Multiple IF, PICK AND MATCH

sunny_talwar — Thu, 13 Aug 2015 16:15:54 GMT

Awesome

I suggest closing the thread by marking a correct answer.

Best,

Sunny

Re: Multiple IF, PICK AND MATCH

maxgro — Thu, 13 Aug 2015 16:40:23 GMT

I don't know what did you want for

not 25 and not 26

so I typed a constant 'no 25 or 26' to be replaced

Re: Multiple IF, PICK AND MATCH

qlikviewwizard — Fri, 14 Aug 2015 03:19:12 GMT

Hi Infock12

Please close the thread by selecting Correct Answer and Helpful. Thank you.

Re: Multiple IF, PICK AND MATCH

infock12 — Fri, 14 Aug 2015 05:13:14 GMT

I Understan. Thanks M!‌

Re: Multiple IF, PICK AND MATCH

infock12 — Fri, 14 Aug 2015 05:14:07 GMT

T‌hanks Sunny, Krishna and Qlikviewwizard!

Re: Multiple IF, PICK AND MATCH

sunny_talwar — Fri, 14 Aug 2015 05:15:43 GMT

No problem Karthik

We are all glad to help.

Best,

Sunny