Qlik Community

Qlik Sense App Development

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

birkirbjorns
New 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
MVP
MVP

Re: How to find Items with zero sales but avl inventory

Maybe like

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

2 Replies
MVP
MVP

Re: How to find Items with zero sales but avl inventory

Maybe like

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

birkirbjorns
New Contributor III

Re: How to find Items with zero sales but avl inventory

Hi Stefan and all,

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

Regards

Birkir

Community Browser