topic Re: Set analysis using dates in QlikView

Set analysis using dates

Thu, 14 Nov 2013 16:08:45 GMT

I’m trying to use set analysis to calculate the revenue sum for the same day the previous week using the following:

SUM({$<Date={$(=Max(Date)-7)}>} MonetaryValue)

But for some reason, I keep getting zero values returned and I can’t understand why. There is definitely revenue there and it works fine if I hardcode the date within the {}.

Thanks

Re: Set analysis using dates

Clever_Anjos — Thu, 14 Nov 2013 16:18:59 GMT

SUM({$<Date={$(=Date(Max(Date)-7))}>} MonetaryValue)

Max() will return a number, not a formatted date

Re: Set analysis using dates

Fri, 15 Nov 2013 09:58:20 GMT

Thanks Clever Anjos, my colleague who was having this problem has managed to get round it using the following syntax:

SUM({$<Date={$(='['&Date(Max(Date)-7)&']')}>} MonetaryValue)