topic Set analysis to use only some weeks in QlikView

Set analysis to use only some weeks

migueldelval — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I´m using the next expression to only show the last 5 weeks, when I select a date.

=Sum({<Date={">=$(=WeekStart(Max(Date)-28))<=$(=Max(Date))"}>}Sales)

But now, I only need to see weeks that are in the same month that selected date.

My Date field its like:

...

16/05/2016

23/05/2016

30/05/2016

...

Thank you in advance

tresB — Thu, 08 Sep 2016 12:32:22 GMT

May be like:

=Sum({<Date={">=$(=WeekStart(MonthStart(Max(Date))))<=$(=Date(Max(Date)))"}>}Sales)

sunny_talwar — Thu, 08 Sep 2016 12:40:06 GMT

Or may be this:

=Sum({<Date={">=$(=Date(WeekStart(Max(Date)-28), 'DD/MM/YYYY'))<=$(=Date(Max(Date), 'DD/MM/YYYY'))"}>}Sales)

migueldelval — Thu, 08 Sep 2016 13:23:40 GMT

Thank you stalwar1 and tresesco,

Finnaly the correct answer was:

=Sum({<Datefield={">=$(=MonthStart(Weekstart(datefield)))<=$(=Max(Datefield))"}>}[Sales)

With this expressión my chart only show weeks that are in month selected in date field.

In order words, if I select Datefield = 30/05/2016. My chart show only 5 weeks; and all of this weeks, Monday it´s in May.

Little bit strange but correct to my requirement.