Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

robinsond31
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