topic Re: Case statement in Load script in Qlik Learning Discussions

Case statement in Load script

Thu, 30 Oct 2014 17:15:24 GMT

Hi,

i'm new to qlikview, can we write a case statement in Load script as we do in the sql select statement? when i try to write the below script its giving me syntax error, can someone please help me in solving this.

CASE WHEN (Product ='Toys')

THEN ([Revenue]+[Tax]+[GP]) ELSE

([Revenue]) END TotalRevenue

Re: Case statement in Load script

swuehl — Thu, 30 Oct 2014 22:54:35 GMT

Try

LOAD

IF( Product = 'Toys', [Revenue]+[Tax]+[GP], [Revenue]) as TotalPrice,

...

FROM ...;

Re: Case statement in Load script

maxgro — Thu, 30 Oct 2014 23:02:44 GMT

load

.....,

if(Product ='Toys'

[Revenue]+[Tax]+[GP],

[Revenue]

) as TotalRevenue,

......

from

......

Re: Case statement in Load script

mark_casselman — Thu, 30 Oct 2014 23:05:40 GMT

Hi,

The CASE statement is not available in QV. Just use IF statement:

IF (Product='Toys',[Revenue]+[Tax]+[GP],[Revenue]) as TotalRevenue

Mark

Re: Case statement in Load script

A_C — Mon, 02 Dec 2019 17:03:44 GMT

Hi Swuehl,

I have a case statement in my SQL select query within qliksense. I keep getting an error when running my load. I am finding that maybe case statements do not work inside Qlik data load editor. How would I write this case statement? Any help would be greatly appreciated!

CASE
SUI.ITEM_TYPE ='B'
THEN SUI.BOM_NET_COST
ELSE SUI.NET_COST
END AS NET_COST

This is what I have but I continue to receive the error message:

IF (SUI.ITEM_TYPE = 'B',
[SUI.BOM_NET_COST],
[SUI.NET_COST])
AS NET_COST