Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

Filtering Data

Hello I need to get a count of Inventory, description and breakdown of inventory received date so that I can filter items with an aging of more than x months. I can get a count of inventory and description but am at a loss om how to filter according to aging. My fields are InventoryName, Description, InventoryDescription and ReceivedDate. Any suggestions would be appreciated 

1 Reply
Vegar
MVP
MVP

I'm assuming your count expression looks like  this

Count( InventoryName)

 and that X months is 6 months. If not then adjust these parts according to your needs.

 

Try this:

Count( {$< ReceivedDate= {">=$(=addmonths(today(),-6))"}>} InventoryName)