topic Set analysis date range in QlikView

Set analysis date range

linhphuong — Mon, 15 Oct 2018 12:03:06 GMT

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

quriouss — Mon, 15 Oct 2018 17:30:09 GMT

Does this work (insert an extra = before the Date2)?

Sum({$<Date3={">=$(=Date2-30)<=$(=Date2-15)"}>}Amount)

linhphuong — Tue, 16 Oct 2018 10:37:37 GMT

Hi,

The solution was to convert the date from numeric to date type.

Thank you for reply