Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
Thanks for the reply Manas, the value here is just Sum(inventory).........no scope for creating a flag
Regards
Sri
any sugesstions
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)
)))
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
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