If condition or two different charts

[NareshGuntur]

Hi,

I have 3 if conditions(again the expressions in the if conditions are complex calculations) in an expression and as expected the performance is not good. I am thinking of having three different charts(with calculation condition as well) and enable them whenever required. Can anyone suggest which way is better?

Cheers,

Naresh

[alexandros17]

It is a good solotion, if you divide the expression in different charts performances will improve, just some other ideas:

1) use set analysis instead of If where you can

2) move elaboration to the script if is possible and use results in the expression

Let me know

[NareshGuntur]

Thanks for the reply

1) use set analysis instead of If where you can

the expressions inside the ifs already have set analysis

let me explain my scenario and suggest me if I can use set analysis....

I have a list box to show data for the last 1 year, 3 year and 5 years.

here the value of the field is checked and based on that the appropriate expression from the if will become active.

2) move elaboration to the script if is possible and use results in the expression

As most of the expressions have set analysis... I felt to keep it in the expression itself.

Cheers,

Naresh

[sushil353]

hi Naresh,

You can also try using variables..

Assign your expression to variable and use them in your chart.. in this way the variable will be calculated only onces.. so if you are using same kind of expression in multiple chart or expression then it is good to have expression saved in variables..

HTH

Sushil

[NareshGuntur]

Hi Sushil,

Thanks for the response.

I am also looking into moving that to a variable. But will I see  a noticeable change is the question that comes to my mind, as it can be stored only as a string that should get evaluated at chart level only as it has Set Analysis.

Cheers,

Naresh

[vinay_hg]

hi i suggest use hide & enable based on the condition intead of nested if or set analysis.