Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
New Contributor

Date Variable in Set Analysis

I have a date field called DateOrdPlaced. I have a variable called vReportDate. It looks like this:  10/31/18. I want to report on all records that have a DateOrdPlaced within the last 30 days of the vReportDate. That is vReportDate -30. Starting with this formula, how can I obtain that?

Does someone have an article or white paper on using date variables in set analysis?

Sum({$<DateOrdPlaced={">$(vReportDate)-30"}>} AmtTotLine)

1 Reply
MVP & Luminary
MVP & Luminary

Re: Date Variable in Set Analysis

Try Sum({$<DateOrdPlaced={">$(=Date#($(vReportDate),'MM/DD/YY')-30)"}>} AmtTotLine)

talk is cheap, supply exceeds demand