topic Re: if condition in QlikView

if condition

upaliwije — Sun, 20 Mar 2016 04:09:52 GMT

if (REM='NOT',YEAR=NUM(YEAR+1),YEAR)AS YEAR

I have above script in my data load script . but It returns ) when the REM=NOT but when REM=YES it is correctly updates as follows

pls advise where I have mad the error

REM YEAR

YES 2012

NOT 0

YES 2013

kkkumar82 — Sun, 20 Mar 2016 04:32:14 GMT

Hi Upali,

As per your script

When the REM value is NOT the year value will return 0 and if it Yes then it would return the same value in year,

Is that what you want.

Please find attached qvw and let me know ur actual requirement.

Thanks

Kiran Kumar

kkkumar82 — Sun, 20 Mar 2016 04:33:07 GMT

Attached file

upaliwije — Sun, 20 Mar 2016 04:44:15 GMT

Thanks

What I want is to add 1 to year if REM=NOT

Eg if year=2012 and rem=not 2013 should be returned

kkkumar82 — Sun, 20 Mar 2016 05:00:15 GMT

Please find attached document, Hope it may help you.

Thanks

Kiran Kumar

upaliwije — Sun, 20 Mar 2016 05:12:17 GMT

Thanks

kkkumar82 — Sun, 20 Mar 2016 05:37:18 GMT

Great to help you, your are welcome.

Thanks

Kiran Kumar