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
Hi
I feel your misplaced wrong field HOUS_GROSS_INCOME_AMT in script
IF(OPEN_DATE<'01JUN2007','PRE','PSOT') as PRE_POST_NCA_IND
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: Simplify the code if possible
- Marcus