topic Re: How to select last 8 weeks default as dimension in QlikView

How to select last 8 weeks default as dimension

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

Hi ,

I have week field it contains weeks till 35 (like 1,2,....35),but now i am displaying week as dimension and sum(sales) as measure.

i want restrict only for last 8 weeks always.How can i define in bar chart .

Thanks,

Kanna

Anil_Babu_Samineni — Tue, 26 Sep 2017 02:49:53 GMT

Try this?

Sum({<Week = {">=$(=Max(Week-8)) <=$(=Max(Week))"}>} Sales)

vinieme12 — Tue, 26 Sep 2017 05:13:17 GMT

Create a numeric Week field if you don't have already and use the numeric value to restrict last 8 weeks in set expression

=Sum({<Week = {">=$(=Max(Week)-8)"}>} Sales)

=Sum({<Week = {">=$(=Max(TOTAL Week)-8)"}>} Sales)