topic Re: If condition or two different charts in QlikView

If condition or two different charts

NareshGuntur — Tue, 09 Sep 2014 07:43:28 GMT

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

Re: If condition or two different charts

alexandros17 — Tue, 09 Sep 2014 07:47:27 GMT

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

Re: If condition or two different charts

NareshGuntur — Tue, 09 Sep 2014 08:35:35 GMT

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

Re: If condition or two different charts

sushil353 — Tue, 09 Sep 2014 08:40:13 GMT

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

Re: If condition or two different charts

NareshGuntur — Tue, 09 Sep 2014 08:45:22 GMT

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

Re: If condition or two different charts

vinay_hg — Tue, 09 Sep 2014 08:46:11 GMT

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