topic Re: Function that returns a chart scale in QlikView

Function that returns a chart scale

Fri, 09 Sep 2011 08:04:36 GMT

Hi,

is there a function or any other way to return the scale of a chart?

My goal is to use it in another chart to set both of them at the same scale.

Thanks in advance.

Function that returns a chart scale

its_anandrjs — Fri, 09 Sep 2011 08:14:32 GMT

Hi,

Yes but when you use the scalling option in axes tab and by the help of the variables for this you need to put variables

for

MinScale

MaxScale

ScaleSep

and use it different charts the same objects

HTH

Regards,

Anand

Function that returns a chart scale

suniljain — Fri, 09 Sep 2011 08:59:01 GMT

are you talking about hieight and width of chart ?.

Function that returns a chart scale

Fri, 09 Sep 2011 09:01:38 GMT

How can I set the variable?

I explain, in my case, the maxscale for Chart 1 should be equal to the biggest bar (over more than 10) in chart 2. But the biggest bar value is not static and might change depending on previous selections.

Re: Function that returns a chart scale

suniljain — Fri, 09 Sep 2011 09:03:20 GMT

pls read apiguide.qvw . you have to write macro for this types of requirement.

Function that returns a chart scale

Fri, 09 Sep 2011 09:03:32 GMT

Only height of the bar. I want the charts to have the same dynamic scale, which would be equal to the biggest bar present on both charts.

Function that returns a chart scale

its_anandrjs — Fri, 09 Sep 2011 09:18:06 GMT

Hi,

Ok understand you need to fix only the height of the bar as Sunil say you need to refer to the Apiguide and to achieve this write a macro code.

Regards

Anand

Function that returns a chart scale

Fri, 09 Sep 2011 09:21:20 GMT

Ok I will do it. I will post an answer if I manage to fix this.

Function that returns a chart scale

Fri, 09 Sep 2011 14:44:24 GMT

I can't figure out how to do the following:

I have 3 different fields: energy, surface, and zone.

I need to calculate for each zone: sum(energy)/(sum(surface) and to return the max.

I tried something like max(aggr(sum(energy)/(sum(surface), zone)), but aggr won't accept the division.

Once I can do this, it will be very easy to post a script. I will just have to stock it in a variable and put it as static max for the scale. Anybody to help me?

Re: Function that returns a chart scale

johnw — Sat, 10 Sep 2011 00:11:08 GMT

You're on the right track, but what you posted has an extra paren before the second sum.

max(aggr(sum(energy)/sum(surface),zone))

Function that returns a chart scale

Mon, 12 Sep 2011 06:01:49 GMT

Thanks a lot John.

I don't even need to use a variable. Just put what John posted as the max scale expression and that's it.

Function that returns a chart scale

johnw — Mon, 12 Sep 2011 17:21:22 GMT

You don't need a variable, but it might be worth considering if you're using the same expression to keep two different charts synchronized. It would be easy for someone maintaining this later to only change one chart and not the other and break what you so carefully assembled. If you put it in a variable, they're much less likely to break it, even if they don't know what you were doing. They'll change the variable, and both charts will be correctly changed.