topic Calculate average by Day in QlikView

Calculate average by Day

prees959 — Mon, 09 Apr 2018 10:47:22 GMT

Hi,

I need to calculate the 'Average Deliveries' by 'Day of the Week' and by a second dimension.

My value field is Total_Deliveries (eg, sum(Total_Deliveries). I have a Day_of_Week dimension and also a Delivery_Slot dimension

What would be the best expression to show average daily deliveries by 'Delivery_Slot' and 'Day_of_Week' ?

PS I am using a standard pivot chart

Many thanks for any advice,

Phil

fvelascog72 — Mon, 09 Apr 2018 11:06:46 GMT

Hi,

You could add the second dimension and a second expression with avg(Total_Deliveries) that should show you what areyou looknig for.

Saludos.

prees959 — Mon, 09 Apr 2018 11:35:21 GMT

Hi,

When I add AVG(Total_Deliveries) it is showing '1'.... any thoughts? Whereas Total for Monday and Slot 'AM' is 913

fvelascog72 — Tue, 17 Apr 2018 15:13:06 GMT

Hi,

Can you attach a example file?

Saludos.