How to select last 8 weeks default as dimension - Qlik Community

Anonymous · ‎2017-09-25

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 · ‎2017-09-25

Try this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vinieme12 · ‎2017-09-26

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)

or

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.