Pivot Table claculation

racheli_zuker — Sat, 16 Nov 2024 06:01:40 GMT

Hello,
Need your assistance with pivot table in Qlik Sense.
The pivot columns are time dimensions (such as month, year, etc.)
The rows are dimensions such as items, customers, etc.
We would like to calculate an average sales per working day.
we are using calendar table with a flag '1' for each working day.
When we are summarizing the days we are getting results only for the days where the items was sold and not for the entire month.
for example: march 2019 : 25 working days, items sold :100K$ in only 2 days only.
we expect that the result will be: 100K/25=4000, but instead we get 100K/2=50K.
**Pivot Table: sum(amount)/sum(working day flag**
Thanks!

Re: Pivot Table claculation

Anil_Babu_Samineni — Tue, 23 Apr 2019 11:39:48 GMT

How about this?

sum(amount)/Count({<Working day flag = {1}>} [working day flag])

topic Re: Pivot Table claculation in App Development

Pivot Table claculation

Re: Pivot Table claculation