topic Re: nested If statements (performance issue) in QlikView

nested If statements (performance issue)

Anonymous — Wed, 18 Sep 2013 16:30:22 GMT

Hi All,

i'm working with nested if condition like

= if( value= 0 or len(value)=0, Black(),
if ( value > 0 and value <=.35, rgb(240,0,0),
if (value>=.50, Green(),
rgb(227,187,28)
)))

is there a way i can write the same expression using pick and mactch function

i'm having some performance issues with my application reason is---- there are so many nested if statements

any suggestions of tweaks in expression for better performance help

Re: nested If statements (performance issue)

manas_bn — Wed, 18 Sep 2013 17:02:44 GMT

If the same expression is used in multiple places, i.e., if the range for "value" is same in many expressions, you could create a flag on the scripting side (using intervalmatch may be) and use the flag in the if condition.

I could be wrong but a numeric flag might help improve performance instead of checking for this condition...

Re: nested If statements (performance issue)

Anonymous — Wed, 18 Sep 2013 17:18:14 GMT

Thanks for the reply Manas, the value here is just Sum(inventory).........no scope for creating a flag

Regards

Sri

Re: nested If statements (performance issue)

Anonymous — Thu, 19 Sep 2013 14:52:51 GMT

any sugesstions

Re: nested If statements (performance issue)

CELAMBARASAN — Thu, 19 Sep 2013 15:10:03 GMT

I can optimize something like

= if( Alt(value, 0) = 0, Black(),
if (value <=.35, rgb(240,0,0),
if (value>=.50, Green(),
rgb(227,187,28)
)))

Re: nested If statements (performance issue)

Anonymous — Thu, 19 Sep 2013 15:17:32 GMT

Thanks for the reply ..but the expression still has 3 if condition i want them to be reduced............ because all my objects have multiple if conditions .....

so this just a sample expression

here is my intial post

http://community.qlik.com/message/392820#392820

Thanks agian

Sri

Re: nested If statements (performance issue)

Anonymous — Fri, 22 Jul 2016 12:30:31 GMT

Hi, Sri,

I think match can not use expression as a parameter.

And nested if conditions can only effect the time consuming when change selections but not the performance if the logic is correct. But of course nested if can easily cause performance issue.

The if expression in your post can not be optimized further, but you can try some improvement for the whole dash:

1. Create some new fields for some if cases in the load script, which actually can make the calculation fast than using if in the dash.

2. Use SET variable for some if expressions which gonna be reused.

Hope this helps

Zhihong