Straight Table to Gauge Chart

Tue, 12 Oct 2010 09:19:05 GMT

Hello All,

I have a problem where I'm trying to get the average Turn Around Time to display in a Gauge Chart. This should be quite simple and I've narrowed the calculation down to two rows so that I can focus on getting it right before working on the T.A.T for all the branches. The problem is that I'm getting the correct average in a Straight Table but when I clone this and convert it to Gauge, the average changes.

I've attached the file.

Please could you assist, it's probably something stupid and small that I'm overlooking.

tx,

Straight Table to Gauge Chart

jagan — Thu, 27 Oct 2011 10:12:16 GMT

Hi,

Try this expression in Gauge chart.

=Sum(AGGR(Avg({<YMDate=DisplayYM,SMD_WarehouseName={'Atlas'}>}(Last_Sales_date - DateReady)),

SMD_Reference, DateReady, Last_Sales_date, SMD_WarehouseName))/Count({<YMDate=DisplayYM,SMD_WarehouseName={'Atlas'}>} DISTINCT SMD_Reference)

Regards,

Jagan.

topic Straight Table to Gauge Chart in QlikView

Straight Table to Gauge Chart

Straight Table to Gauge Chart