Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
birkirbjorns
Contributor III
Contributor III

How to find Items with zero sales but avl inventory

Hi,

I have a small proplem that I am having some problems solving. I have to find items that have not been sold for the last 120days but are avl in our warehouse.

I found a thread here that helped me find the items with no sales. But I do not know how to add the second measure to the mix.

This is the expression

Count({<[ItemNo]={"=Sum([120 days sales]) = 0"}>} distinct [ItemNo])

So any hints on adding InventoryQty !=0 ?

Regards and Merry Christmas

Birkir

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like

Count({<[ItemNo]={"=Sum([120 days sales]) = 0 and Sum(InventoryQty)<>0"}>} distinct [ItemNo])

View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe like

Count({<[ItemNo]={"=Sum([120 days sales]) = 0 and Sum(InventoryQty)<>0"}>} distinct [ItemNo])

View solution in original post

birkirbjorns
Contributor III
Contributor III
Author

Hi Stefan and all,

Thank for your input this works like a charm, thanks for the assistance and Merry Christmas

Regards

Birkir