topic Straight Table to Gauge changing values in QlikView

Straight Table to Gauge changing values

Thu, 14 Oct 2010 10:44:47 GMT

Hi,

I have a straight table showing the correct result of a simple calculation I'm doing to narrow down a bigger problem but when I convert the table to a gauge as it should be displayed, the values show differently on the gauge and the gauge's text in chart.

I've attached a simplified version of the file.

thanks,

Straight Table to Gauge changing values

Thu, 14 Oct 2010 13:34:09 GMT

Hi,

You need to use function AGGR because you have a dimension on the gauge.

But the gauge show the last value, so i do the AVG how your straight table "36.50".

In Text Chart (Gauge) use this formula:

"=AVG(AGGR(avg({<YMDate=DisplayYM,SMD_WarehouseName={'Atlas'}>} (Last_Sales_date - DateReady)), SMD_Reference, DateReady, Last_Sales_date, SMD_WarehouseName))"

Straight Table to Gauge changing values

Thu, 14 Oct 2010 15:09:25 GMT

Hi Eduardo,

Thanks for the reply. It works perfectly for the text in chart but the gauge chart's needle doesn't show the same value.

Why would that be happening?

Straight Table to Gauge changing values

Thu, 14 Oct 2010 15:24:45 GMT

Hi, I believe that just show the last value for you chart.

If you change your chart to Straight table, you can see two rows, and the value that show are the last.

If you copy the expression in the text chart and delete all dimensions, to expression chart values will be show correct.

Straight Table to Gauge changing values

Fri, 15 Oct 2010 05:29:01 GMT

Thank you very much Eduardo, I appreciate your help. It works now.