Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Lost sales

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

3 Replies
MVP
MVP

Lost sales

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.

spividori
Valued Contributor

Lost sales

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.

Not applicable

Lost sales

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

Community Browser