Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

AVERAGE ISSUE

Hello all,

how can I calculate the average product sold in one month ,  where the divisor is not only the dates where the product is sold, but the total number

of dates in that period.

see abstracted example

Thanks in advance!

1 Solution

Accepted Solutions

Re: AVERAGE ISSUE

Try: sum(Customer)/interval(monthend(max(Date))-monthstart(min(Date))-1,'D')


talk is cheap, supply exceeds demand
2 Replies

Re: AVERAGE ISSUE

Try: sum(Customer)/interval(monthend(max(Date))-monthstart(min(Date))-1,'D')


talk is cheap, supply exceeds demand
Not applicable

Re: AVERAGE ISSUE

Thanks this works!!

Do you have also a suggestion to calculate this in case days are split in morning, -7-16, evening,17-24,

night 1- 6?

Community Browser