Set Analysis question - rolling dates

Anonymous — Sun, 22 Oct 2017 01:06:35 GMT

Hi,

I'm trying to limit a bar chart to show only the past 8 weeks worth of total Events. Have googled lots of responses and found ways of restricting to a date range, but not really a solution that acts like a rolling 8 weeks.

It works fine without the "-56" to get me the latest date, but as soon as I put -56 in, it doesn't work. Then I tried wrapping a Date function around the =Max...-56 but that didn't work either. I think I'm getting the syntax wrong?

Count({1<DateField={">=$(=Max(DateField)-56)"}>} Event_Id)

Was hoping someone could help?

Re: Set Analysis question

Anonymous — Sun, 22 Oct 2017 01:18:39 GMT

Edit: (Should also be 48, not 56)

Nevermind, got it!

Count({1<DateField={">=$(=Date(Max(DateField)-48))"}>} Event_Id)

Re: Set Analysis question

Anil_Babu_Samineni — Sun, 22 Oct 2017 15:33:06 GMT

You can mark your response as correct answer

topic Re: Set Analysis question in QlikView

Set Analysis question - rolling dates

Re: Set Analysis question

Re: Set Analysis question