Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

If statement...


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

1 Solution

Accepted Solutions
prma7799
Honored Contributor III

Re: If statement...

Try like this

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

Thanks

Prashant

3 Replies
prma7799
Honored Contributor III

Re: If statement...

Try like this

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

Thanks

Prashant

prma7799
Honored Contributor III

Re: If statement...

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

MVP
MVP

Re: If statement...

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



OR


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

as AMOUNT


Hope it helps you.


Regards,

Jagan.


Community Browser