topic Re: My way of writing CASE WHEN ELSE statement in QlikView

My way of writing CASE WHEN ELSE statement

Sun, 29 Nov 2015 09:07:34 GMT

Question: How to write the following T-SQL statement in Qlik?

SELECT

MyNumber,

CASE

WHEN MyNumber = 1 THEN 'One'

WHEN MyNumber = 2 THEN 'Two'

ELSE 'Three or more'

END AS MyText

FROM ...

Syntax:

Using PICK and MATCH functions with a value of TRUE to compare with:

PICK (MATCH (-1, Condition1, Condition 2, -1), Result1, Result2, Default Result)

Solution:

LOAD

MyNumber,

PICK ( MATCH (-1, MyNumber = 1, MyNumber = 2, -1), 'One', 'Two', 'Three or more') AS MyText

FROM ...

Please let me know your opinion about it, or if you have a better way for writing that.

If you want to check, just copy and paste the following:

LOAD *, PICK ( MATCH (-1, MyNumber = 1, MyNumber = 2, -1), 'One','Two','Three or more') AS MyText;

LOAD * INLINE [MyNumber

];

Re: My way of writing CASE WHEN ELSE statement

maxgro — Sun, 29 Nov 2015 18:44:00 GMT

PICK ( WILDMATCH (MyNumber, 1, 2, '*'), 'One','Two','Three or more') AS MyText

Re: My way of writing CASE WHEN ELSE statement

Tue, 01 Dec 2015 15:31:08 GMT

That makes it easier.

Thank you

Re: My way of writing CASE WHEN ELSE statement

maxgro — Tue, 01 Dec 2015 18:07:49 GMT

could you close the thread? thanks

Re: My way of writing CASE WHEN ELSE statement

Sun, 06 Dec 2015 06:35:13 GMT

Sorry I don't know how to close a thread. Please advise

Re: My way of writing CASE WHEN ELSE statement

oknotsen — Sun, 06 Dec 2015 12:26:41 GMT

You do so by flagging the correct answer as "Correct Answer".

But for that to be an option, you need to start a question as a question to begin with; you started a discussion.

I have converted it to a question and you can now mark the Correct Answer.

Onno

Community Team member

Re: My way of writing CASE WHEN ELSE statement

maxgro — Mon, 07 Dec 2015 07:23:09 GMT

Ops, I didn't know this (Correct Answer only for question) difference; thanks for the explanation.

Re: My way of writing CASE WHEN ELSE statement

oknotsen — Mon, 07 Dec 2015 20:12:49 GMT

Happy I could help and having the rare opportunity to learn a MVP something new .