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
sunilkumarqv
Specialist II
Specialist II

Hi

I feel your misplaced wrong field HOUS_GROSS_INCOME_AMT in script

sunilkumarqv
Specialist II
Specialist II

IF(OPEN_DATE<'01JUN2007','PRE','PSOT') as PRE_POST_NCA_IND

marcus_sommer

AFAIK there is a limit of nested if-loops from 99 but in almost each case you should avoid such large nested expressions especially if this are if-loops. The error-proneness is extremly high (who would like to maintain it?) and the performance is often bad. Better is it to use mapping with applymap or pick(match()) structures and using of (parametrized) variables to improve the performance and the readability.

Don't join - use Applymap instead

Re: Substitute to nested ifs

Re: Simplify the code if possible

- Marcus