topic Re: Case When Help in QlikView

Case When Help

Tue, 22 Oct 2013 10:31:18 GMT

Hi All

I'm new to qlikview. Can somebody help me explain why this case statement doesn't work in the back end?

CASE

WHEN vhl_1_age = 0 THEN 'A'

WHEN vhl_1_age = 1 THEN 'B'

ELSE vhl_1_age

END AS vhl_1_age_Grouping

Thanks

Re: Case When Help

Anonymous — Tue, 22 Oct 2013 10:36:47 GMT

Hi James,

The when case should be used only with full scripts, example:

Case var 1

When 2

load * from table1

when 3

Load * from table2

Etc..

For what you are trying to do, use the if statement.

Regards

Re: Case When Help

israrkhan — Tue, 22 Oct 2013 10:40:45 GMT

hi, i think ' ' mark are missing

CASE

WHEN vhl_1_age = 0 THEN 'A'

WHEN vhl_1_age = 1 THEN 'B'

ELSE 'vhl_1_age' ....was missing

END AS vhl_1_age_Grouping

.......................................................................

below is working in mytable

SELECT productid, productname, unitprice,

CASE

WHEN unitprice < 20.00 THEN 'Low'

WHEN unitprice < 40.00 THEN 'Medium'

WHEN unitprice >= 40.00 THEN 'High'

ELSE 'Unknown'

END AS pricerange

FROM Production.Products;

Re: Case When Help

Gysbert_Wassenaar — Tue, 22 Oct 2013 10:42:01 GMT

You can try using a nested if or a pick statement:

LOAD

if(vhl_1_age=0,'A', if(vhl_1_age=1,'B',vhl_1_age)) as vhl_1_age_Grouping

FROM ...mysource...;

LOAD

pick(vhl_1_age+1),vhl_1_age,'A','B') as vhl_1_age_Grouping

FROM ...mysource...;

Re: Case When Help

Tue, 26 Nov 2013 13:18:08 GMT

I want to do the same in the script so i do not have to convert the values in every graph, but the read fail. I have tried it directly in SQL manager and it works, but not in the script.

Have tried i bit different versions, but it fails every time.

load *

;

SQL

select

f.BirthDate As Fødselsdag,

f.ExtType as Skyldnertype,

CASE

WHEN f.ExtType = '1' THEN 'Privat'

WHEN f.ExtType = '2' THEN 'Bedrift'

WHEN f.ExtType = '3' THEN 'ENK'

else 'Ukjent'

end as Skyldnertype,

d.StartedDate as KampanjeStart,

Re: Case When Help

Tue, 26 Nov 2013 13:22:45 GMT

And as I read my own code I found what was wrong. Same name in two settings worked fine in SQL manager, but not in the script.

Now i changed name og one field and it works fine, just as I wanted.