Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Rama,
Try this:
Count(distinct{<[WeekSerial]={">$(=max(WeekSerial)-8)<=$(=max(WeekSerial))"}> - <[WeekSerial]={">$(=max(WeekSerial)-4)<=$(=max(WeekSerial))"}>} [metricfield])
Jordy
Climber