Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Frequency of sales

Hi guys,

I'm trying to find out, for each product, the frequency of sales, e.g. I would like to know that I sell a unit of product every "x" days (on average).

Any idea on how to do that?

Thanks a lot in advance!

2 Replies

try: interval(max(salesdate)+1-min(salesdate))/sum(units)

talk is cheap, supply exceeds demand
Contributor III
Contributor III

Hi Gysbert,

thanks a lot for your help!

I've played a while with your suggestion and at the end I've come to a different solution:


that's why I want to know how many times I've sold a product (the count part of the expression) in a range of time that is from it's first sale and today.

You've been precious!

Thanks again