Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've created a table to analyse deadstock (non-selling stock) in our organisation and have added the below objects into the table for data visualisation:
- Brand name of deadstock product (Row dimension)
- Product Code (Row dimension)
- Product Description (Row dimension)
- Physical stock on hand count (measure)
- Net cost of product (measure)
- Most Recent Sale Date (measure)
- Product created date (measure)
Deadstock is defined as:
- Any product that hasn't sold in 3 months
- Has a Product Created Date older than 6 months
Now, I'm trying to add a filter to the table based on the above criteria, this is where I'm encountering the issue. When I try to add PRODUCT_CREATEDDATE as filter type condition -> set to compare -> condition: greater than fixed value -> AddMonths(today(), -6)
This doesn't return anything, probably due to the fact I'm using Qlik code in specify the fixed value, but I wanted this value to be dynamic.
Hi
May be if today() is corresponding to MAX ( PRODUCT_CREATEDDATE )
then (AddMonths(MAX ( PRODUCT_CREATEDDATE ) , -6)