I have a situation where i have to use If condition which has the criteria that based up on the selection on one of the field value, there are two different expressions that needs to picked up based on the value selected. Now, after implementing the If condition everything works to whats needed but the calculation time becomes much higher that it takes atleast couple of seconds to load the pivot table. In this couple of seconds is fairly negligible but i would like to consider any option that can still give the desired result with much lesser calculation time?
PFA- for example- as i cannot publish the actual app i have created a mock up but ultimately the goal is to reduce the calculation time when a selection is made on the report select there are different expressions needs to be calculated depending upon the expression.
Few things that i considered,
-Definetly i can consider this option using a variable would be better, but this an application enhancement( in this case i would need to recreate quite a few expressions)
-done as much as i can on preset condition to be implemented in the script itself already.
even if i use the Sum(if(.... it is quite negligible difference in the calculation time. As i have too many expressions on the chart. Considerable option though.
I would propose that you replace the use of EXP3 by the following: $(=Expression)
Based on your selection in the Select field, the appropriate Expression shall be calculated, without going through the If() condition, which could be practical if your real expression is rather complex, or in the case where you have several imbricated If() statements.
Please find attached a new version of your original qvw file, including the proposed changes.
