Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
Are there a number of IF statements allowed in the Qlikview script?
Because some of my IF statements are just not highlighted by the program.
Please assist,
Thanks
please post a sample
The syntax color coding sometimes shows a different result than the what the real parser evaluates. So the question is: Does your script run or not?
However - I've tested a large number of nested If:s, and it seems to work fine, so I suspect that there is something else...
HIC
Try to comment the if(match.............)
I think there is a syntax error, so your if are not highlighted because they are after the error
Ok I commented it out and it looks ok, but what could the issue with the if(match...statement?
You have an error at
If(Match(CUSTOMER_RACE_CODE(
There should not be any parenthesis after CUSTOMER_RACE_CODE
HIC
Hi, D Mbini.
Try replace line 27 by
if(Match(CUSTOMER_RACE_CODE,'A','C','I')
,'Y'
,'N'
) AS [HDP IND],
I hope this helps!
Thanks a lot Gentlemen highly appreciated.
heres my code I want to convert to Qlikview:
CASE WHEN OPEN_DATE < ''01JUN2007'' THEN ''PRE'' |
ELSE ''POST'' END AS PRE_POST_NCA_IND |
Hi,
Your question is different from current topic. Start a new thread for this query.
Please close the thread by selecting Correct Answer.
Thank you.