Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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)