How can i add week as separate object in my dashboard in Qlik sense Visualization chart

[Rama1]

Hi, 

I have my Dashboard with the tables and chart with the last 4 weeks data (few tables and Chart with last 6 months data) and I am generating this week last 4 weeks Report.

Eg:  I am using this expression in Set Analysis to generate last 4 weeks data.

Count(distinct{<[WeekSerial]={">$(=max(WeekSerial)-4)<=$(=max(WeekSerial))"}>} [metricfield])

,If am in 47 week am generating 46,45,44,43 weeks report

Now I want to generate Before last 4 weeks report Eg: i want to generate 45,44,43,42 in 47 week.

Can someone help in this please?

I am confused how to do this either in Load or in set analysis or in Nprinting as i am new to Qlik.

[JordyWegman]

Hi Rama,

Try this:

Count(distinct{<[WeekSerial]={">$(=max(WeekSerial)-8)<=$(=max(WeekSerial))"}> - <[WeekSerial]={">$(=max(WeekSerial)-4)<=$(=max(WeekSerial))"}>} [metricfield])

Jordy

Climber