topic Poor Performance because of Nested If-Else in QlikView

Poor Performance because of Nested If-Else

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

We have a requirement, in which we have to choose the Dimensions as per selection in MultiBox values.

PFA, the demo application, in which I have created two Text Objects, one is "DrillDown Value" which indicates the value of one dimension and "Even DrillDown Value" which indicates the second Dimension Value.

Both the expressions in the Text Object has Nested If-Else statements, because of which we are facing poor performance issues.

We have tried -

1> DrillDown Object, for DrillDown Value, but it fails, when there is a single value in the child, it directly moves to GrandChild Value.

2> We thought to have CASE statements in Script, but it may not be possible, as we want the value to come as per selection from User.

Could you please provide any workaround for both the expressions.

Thanks & Regards,

Re: Poor Performance because of Nested If-Else

mrossoit — Fri, 08 May 2015 09:18:18 GMT

Hi,

I don't know if this solution could be right for your case.

I suggest you to give to the user the possibility to chose the 2 dimensions he want to use changing the value of 2 different variables.

Check out the attachment.

Regards

Re: Poor Performance because of Nested If-Else

peter_turner — Fri, 05 Jun 2015 09:53:53 GMT

Hi MK,

Have you read the blog by Rob Wunderlich called 'how not to choose an expression'?

He explains how QV calculates IF statements and that it will calculate both possible outcomes of the IF even we think it shouldn't. He also shows how to code around this and it might help the performance of your app!

Re: Poor Performance because of Nested If-Else

peter_turner — Fri, 05 Jun 2015 09:54:13 GMT

Sorry here's the direct link How Not to Choose an Expression | Qlikview Cookbook

Re: Poor Performance because of Nested If-Else

marcus_sommer — Sun, 07 Jun 2015 10:08:36 GMT

I think this could be helpful for you: https://community.qlik.com/message/723682#723682

- Marcus