Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an issue with date range in set analysis. I have checked many an examples on qlikhelp but none seem to work.
I have 3 columns Amount, Date2 and Date3 and I want to sum the amounts for all Date3 that is between 30 and 15 days before date2.
My expression is following:
sum({<Date3={">=$(Date2-30)<=$(Date2-15)"}>} -Amount)
And the Dimension is Date2
Thanks for reply
Does this work (insert an extra = before the Date2)?
Sum({$<Date3={">=$(=Date2-30)<=$(=Date2-15)"}>}Amount)
Hi,
The solution was to convert the date from numeric to date type.
Thank you for reply