topic chart in pivot table in QlikView

chart in pivot table

francis_gr — Fri, 24 Dec 2010 14:57:24 GMT

Hi!

In my example pivot table, i have one chart expression,

As you can see, always shows the values just over the limit between values and not inside the section and in dependig the empleado that you select it doesn`t show anything in Total Line.

How can I solve those two problems??

regards!

chart in pivot table

Fri, 24 Dec 2010 15:59:51 GMT

try doing the sum(Tramos_Limite1) in the chart expresiion

and modify the limits of the indicator, since the values exceed 3, you should adjust that limit or use the average instead of sum

chart in pivot table

Fri, 24 Dec 2010 20:28:44 GMT

It looks like you have the autowidth checkbox set for the gauge settings, try unclick that and set your own limits for the colors and you will be all set.

chart in pivot table

francis_gr — Mon, 27 Dec 2010 21:02:53 GMT

Hi Fabián!

Thanks for your reply.

I've tried to follow your suggestions but no avail.

I have change the values in my sample QV "Prueba". Now the values can be in 3 possible ranks.

As you can see, if no selection is done, total line for "tramos" doesn´t show the right value.

Can you suggest to me how to form the chart?? (min and max values, segment configuration, scale...)

Regards

chart in pivot table

francis_gr — Mon, 27 Dec 2010 21:11:13 GMT

Hi John!

Thaks for your reply.

If i unclik the autowidth checbox, the full area in my chart gets red so really don`t know if i'm doing ok.

have you got another option?

Please chek my example. I've changed the values so now I have 3 possible ranks to show

Regards

chart in pivot table

Tue, 04 Jan 2011 12:27:52 GMT

The entire area turns red due to the limits you have set for the color.

Try to set the limits static first so you see the give you the right colors and make sure the range is high enough to include the last limit.