Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how many IF statement allowed in Qlikview script

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

12 Replies
sasiparupudi1
Master III
Master III

please post a sample

Not applicable
Author

SAMPLE.jpg

hic
Former Employee
Former Employee

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

maxgro
MVP
MVP

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

Not applicable
Author

Ok I commented it out and it looks ok, but what could the issue with the if(match...statement?

hic
Former Employee
Former Employee

You have an error at

If(Match(CUSTOMER_RACE_CODE(

There should not be any parenthesis after CUSTOMER_RACE_CODE

HIC

jonas_rezende
Specialist
Specialist

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!

Not applicable
Author

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
qlikviewwizard
Master II
Master II

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.