topic Are there any function like switch case? in QlikView

Are there any function like switch case?

Tue, 25 Jan 2011 08:18:03 GMT

Hi,

I was wondering whether there are some function like switch case.

Allow me to take an example:

In the expression: I can use If clause to judge, but it is limited to 2 choices, but I want to get more than 2 choices.

Thanks.

deepakk — Tue, 25 Jan 2011 10:12:17 GMT

hi,

You can use the Match function to achieve the same

eg:

if(match( Year, 2000,2001,2002)>0,1)

I hope this helps.

Tue, 25 Jan 2011 10:16:46 GMT

I mean, I want this one:

If year=2000 then A , year=2001 then B, year=2002 then C.

How to do?

Tue, 25 Jan 2011 11:02:23 GMT

Hi Isaac,

Check if below code helps you.

pick(wildmatch(Year,2000, 2001,2002,'*'),'A', 'B', 'C', 'Other')

- Sridhar