Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bmenicucci
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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
bmenicucci
Contributor III
Contributor III
Author

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:

interval(vToday-min(salesdate))/count(invoices)

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

Cheers