topic Dynamice Expression In Axis Question! in QlikView

Dynamice Expression In Axis Question!

Tue, 17 Nov 2009 18:38:15 GMT

Hi guys,

I have a chart on which I would like to have an expression within the 'static min'. I would like it to have a scale where it shows a percentage below the minimum value displayed. So in my expression I tried:

=Sum(Min([$(vOverviweMonthlyUptime)]) - 1.0 [\code]
This just displays the axis at the minimum value and not a percentage below. Even if I changed the numeric figure from 1 to anything esle, it does not change anything. Does anyone know why this is the case?
Thanks in advance



 </body>

Dynamice Expression In Axis Question!

Tue, 17 Nov 2009 19:16:27 GMT

Try removing SUM() from the expression, you should just need the MIN() part.

If, however, you want to do a minimum of the sum of.......

In this case you should use Min(Aggr(Sum(........ where you aggregate over the dimension(s) you are using in the chart.

Dynamice Expression In Axis Question!

Tue, 17 Nov 2009 19:59:08 GMT

Hi Nigel,

I did try this without the Sum but again no change:

=min([$(vOverviewMonthlyUptime)]) - 1.0

I also tried the aggr option:

=Min(Sum (Aggr([$(vOverviewMonthlyUptime)]),irMonthYear)-1.0 )

irMonthYear is the only dimnesion I use in this chart.

Neither seem to have worked unfortunately

Dynamice Expression In Axis Question!

Tue, 17 Nov 2009 20:07:59 GMT

Can you post an example app?