Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Rama1
Contributor II
Contributor II

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

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.

 

 
 
 
1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi Rama,

Try this:

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

Jordy

Climber 

Work smarter, not harder