topic Help with Window Title in Gauge Chart! in QlikView

Help with Window Title in Gauge Chart!

Fri, 22 Oct 2010 11:24:25 GMT

Hi All,

I am using the below expression in gauge chart. The result are getting displayed in the in proper format. Could you please tell me what exactly I need to do so that it displays the result in correct format.


====date(makedate(Max(Year), Max(Month)), 'MMM YYYY') &' vs ' & date(makedate(Max(Year), Max(Month-1)), 'MMM YYYY')& ' Sales Growth @ ' & num(Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month))}>} SalValue) / Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month)-1)}>} SalValue), '#%')

Help with Window Title in Gauge Chart!

renjithpl — Fri, 22 Oct 2010 11:34:34 GMT

i think its to do with your numbering format. Try '##.##%'

regards

Ren

Help with Window Title in Gauge Chart!

Anonymous — Fri, 22 Oct 2010 11:34:46 GMT

Rikab,
Instead of '#%', try '#0%'

Help with Window Title in Gauge Chart!

Fri, 22 Oct 2010 11:48:10 GMT

Hi All,

I already tried both the method but it shows different value. Explained it in the below screen shot.

Help with Window Title in Gauge Chart!

renjithpl — Fri, 22 Oct 2010 12:35:30 GMT

Hi Rikab,

Can you send the data which you are getting when you do your below code.

1. Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month))}>} SalValue) ????

and

2. Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month)-1)}>} SalValue) ????

Regards

Ranjit

Help with Window Title in Gauge Chart!

Fri, 22 Oct 2010 12:52:37 GMT

Hi,

Do you have any dimension in your gauge chart?

Maybe you need to use the aggr function.

Help with Window Title in Gauge Chart!

Fri, 22 Oct 2010 13:02:37 GMT


Eduardo Correa wrote:
Do you have any dimension in your gauge chart?
Maybe you need to use the aggr function. <div></div>

Yes, Dimension is there.

Help with Window Title in Gauge Chart!

Fri, 22 Oct 2010 13:04:25 GMT

Hi Ranjit,

This is what I am using in the expression. mfacname is there in the dimension.

Sum({$<Year={$(=Max(Year))}>} SalValue) / Sum({$<Year={$(=Max(Year)-1)}>} SalValue)

Help with Window Title in Gauge Chart!

Fri, 22 Oct 2010 13:08:59 GMT

I think that the result "10.xxxxxx" are a partial result because you have a dimension in your chart.

How in the title don't have dimension group by the function AGGR the result are "28%".

If you change your chart to straight table, how many rows return?

Help with Window Title in Gauge Chart!

renjithpl — Fri, 22 Oct 2010 13:16:15 GMT

I meant, the values you are getting seperately

1. Sum({$<Year={$(=Max(Year))}>} SalValue)

2. Sum({$<Year={$(=Max(Year)-1)}>} SalValue)

Normally when i get such errors, i calculate the values in a normal calculator, and analyse where the changes need to be done. sometimes, it accepts *100 or /100 will give the right answer.

I am not sure, but i will try definetly. 🙂

Regards

Help with Window Title in Gauge Chart!

Anonymous — Fri, 22 Oct 2010 13:18:21 GMT

Hmm, I thought the question was about the format, not the data...
Assuming the result of the gauge chart is correct, the expression in tiltle must be exactly ther same as in chart, whatever it is, and formatted as suggested above.
In this particular case I doubt the the chart is correct - gauge chart should not use dimensions. From what I can tell, if you use a dimension in a gauge chart, it behaves as if one value of this dimension is selected. I assume that if you remove dimension, the result will be 28%.

Help with Window Title in Gauge Chart!

Fri, 22 Oct 2010 13:56:42 GMT

Hi Micheal,

Yes! After removing the dimension it works. You mean to say that now shows the overall growth. On selection this growth will vary or else it will show over all growth.

Thanks and Regards,

Rikab