topic Re: How to write IF statement in load script in QlikView

How to write IF statement in load script

Anonymous — Tue, 16 Jul 2013 10:24:21 GMT

Hi experts,

Can anyone help me how to write if statement in load script. I try below script and get error.

Currency='USD' then
Sale*Exchange
Else Sale

End If as Sale,

Re: How to write IF statement in load script

Sokkorn — Tue, 16 Jul 2013 10:27:19 GMT

Hi Sir,

This script is not correct in QlikView. Now let try:

[Data]:

LOAD

...

If(Currency='USD',Sale*Exchange,Sale) As [Sale],

...

Regards,

Sokkorn

Re: How to write IF statement in load script

Anonymous — Tue, 16 Jul 2013 10:31:12 GMT

Sokkorn, it work!!!. Can you help to explain me on your statement?

Re: How to write IF statement in load script

Sokkorn — Tue, 16 Jul 2013 10:33:18 GMT

Hi,

If(Condition, then, else)

The three parameters condition, then and else are all expressions. The first one, condition, is interpreted logically. The two other ones, then and else, can be of any type. They should preferably be of the same type. If condition is true, the function returns the value of the expression then. If condition is false, the function returns the value of the expression else.

Example:

If(Amount>= 0,'OK','Alarm')

Regards,

Sokkorn

Re: How to write IF statement in load script

Tue, 16 Jul 2013 10:33:42 GMT

Load

If(Currency='USD',Sale*Exchange,Sale) As [Sale]

From Source table....

Re: How to write IF statement in load script

Anonymous — Tue, 16 Jul 2013 10:34:48 GMT

Thanks bika_2010

Re: How to write IF statement in load script

Anonymous — Tue, 16 Jul 2013 10:35:43 GMT

Thank you Sokkorn. Very nice