topic Lost sales in QlikView

Lost sales

Thu, 30 Dec 2010 13:14:11 GMT

Hi all,

I would like to know how do I not have the sales in the period?
I already have the sales made now would like to know which products were not sold in that period?
Thanks,
Gleybson Fernandes

Lost sales

Miguel_Angel_Baeyens — Thu, 30 Dec 2010 13:29:05 GMT

Hello,

Assuming that those who haven't sales for the period are all but those who do have sales, using set analysis the expression to return the count may look like

Count({1 - < ID = {"=Sum({< Date = {'>=$(=Date(PeriodStart))<=$(=Date(PeriodEnd))'} >} Sales) > 0"} >} ID)

Meaning all IDs except for those that have Sales in the period greater than zero. Above syntax may require some cleanup.

Hope this helps.

Lost sales

spividori — Thu, 30 Dec 2010 20:56:41 GMT

Hi MIguel.

I have a similar query, I need to select a client to display all products that do not buy, unspecified period.

The fields of my table are: Customer, Product and Quantity.

Regards.

Sandro.

Lost sales

Thu, 30 Dec 2010 22:02:17 GMT

Miguel, thank you for the post but did not resolve.
have any other suggestions?