topic Re: Case statement in Load Script in QlikView

Case statement in Load Script

Thu, 30 Oct 2014 17:53:48 GMT

Hi,

i'm new to Qlikview, Is it possible to write a case statement in the Load script? i'm trying to write the below script and its giving syntax errors. can someone please help me in figuring out this.

CASE WHEN (Product ='Toys')

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

([Revenue]) END TotalPrice

Re: Case statement in Load Script

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

Try

LOAD

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

...

FROM ...;

Re: Case statement in Load Script

simondachstr — Thu, 30 Oct 2014 22:58:42 GMT

if(Product = 'Toys',

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

[Revenue]

) AS TotalPrice

Re: Case statement in Load Script

danieloberbilli — Thu, 30 Oct 2014 22:59:10 GMT

You can look up the conditional functions in help e.g. if then else. Or Sub...end sub if you need a loop to create fields/tables.

Maybe something like this works for you:

Load

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

resident / from...

Re: Case statement in Load Script

jaimeaguilar — Thu, 30 Oct 2014 23:33:39 GMT

Hi,

I think the When statement, as well as Case are control structures for altering the behaviour of complete blocks of script (for example full tables).

What you describe can be done either with pick(match()) or if. Pick(match()) can be useful if you have several escenarios like

pick(match(Product, 'Toys','Fruits','Furniture'), Formula1, Formula2, Formula3) as Field

otherwise it would be better with an if

regards

Re: Case statement in Load Script

Fri, 31 Oct 2014 11:58:25 GMT

Thanks Everyone!!