topic Re: how many IF statement allowed in Qlikview script in QlikView

how many IF statement allowed in Qlikview script

Mon, 07 Sep 2015 18:39:01 GMT

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

Re: how many IF statement allowed in Qlikview script

sasiparupudi1 — Mon, 07 Sep 2015 18:41:18 GMT

please post a sample

Re: how many IF statement allowed in Qlikview script

Mon, 07 Sep 2015 18:49:42 GMT

Re: how many IF statement allowed in Qlikview script

hic — Mon, 07 Sep 2015 18:52:57 GMT

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

Re: how many IF statement allowed in Qlikview script

maxgro — Mon, 07 Sep 2015 18:53:55 GMT

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

Re: how many IF statement allowed in Qlikview script

Mon, 07 Sep 2015 19:02:01 GMT

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

Re: how many IF statement allowed in Qlikview script

hic — Mon, 07 Sep 2015 19:02:11 GMT

You have an error at

If(Match(CUSTOMER_RACE_CODE(

There should not be any parenthesis after CUSTOMER_RACE_CODE

HIC

Re: how many IF statement allowed in Qlikview script

jonas_rezende — Mon, 07 Sep 2015 19:12:26 GMT

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!

Re: how many IF statement allowed in Qlikview script

Mon, 07 Sep 2015 19:25:28 GMT

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

Re: how many IF statement allowed in Qlikview script

qlikviewwizard — Tue, 08 Sep 2015 00:15:56 GMT

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.

Re: how many IF statement allowed in Qlikview script

sunilkumarqv — Tue, 08 Sep 2015 05:03:25 GMT

I feel your misplaced wrong field HOUS_GROSS_INCOME_AMT in script

Re: how many IF statement allowed in Qlikview script

sunilkumarqv — Tue, 08 Sep 2015 05:05:18 GMT

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

Re: how many IF statement allowed in Qlikview script

marcus_sommer — Tue, 08 Sep 2015 05:27:14 GMT

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