topic Re: If statement... in QlikView

If statement...

Mon, 16 Feb 2015 03:51:12 GMT

Hi All,

Please see below, what the problem with my script:

IF (CURR='AU','US'), (num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL as AMOUNT

Please help me...

THANKS & REGARDS

prma7799 — Mon, 16 Feb 2015 04:08:01 GMT

Try like this

IF ((CURR='AU' or 'US'), (num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL) as AMOUNT

Thanks

Prashant

prma7799 — Mon, 16 Feb 2015 04:09:12 GMT

IF ((CURR='AU' or 'US'), num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL as AMOUNT

jagan — Mon, 16 Feb 2015 06:08:32 GMT

Hi,

I think the expression should be

IF ((CURR='AU' or CURR='US'), (num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL)

as AMOUNT

IF ((Match(CURR, 'AU', 'US'), (num((AMOUNT_MTD_ACTUAL)*(KURS_RATE))*-1), AMOUNT_MTD_ACTUAL)

as AMOUNT

Hope it helps you.

Regards,

Jagan.