Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
robinsond31
Contributor
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
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand