Using a date range as a calculated value filter

HClegg — Wed, 31 Jan 2024 16:48:31 GMT

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.

Re: Using a date range as a calculated value filter

brunobertels — Wed, 31 Jan 2024 17:17:40 GMT

May be if today() is corresponding to MAX ( PRODUCT_CREATEDDATE )

then (AddMonths(MAX ( PRODUCT_CREATEDDATE ) , -6)

topic Re: Using a date range as a calculated value filter in App Development

Using a date range as a calculated value filter

Re: Using a date range as a calculated value filter