Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

Set Analysis question - rolling dates

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?

1 Solution

Accepted Solutions
Highlighted
New Contributor

Re: Set Analysis question

Edit: (Should also be 48, not 56)

Nevermind, got it!

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

View solution in original post

2 Replies
Highlighted
New Contributor

Re: Set Analysis question

Edit: (Should also be 48, not 56)

Nevermind, got it!

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

View solution in original post

Highlighted

Re: Set Analysis question

You can mark your response as correct answer

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)