Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
mhghotbi
Contributor
Contributor

display values for last 8 weeks by default

Hello,

There is an analytics sheet created with qlikview for our company, and the sheet is full of charts and numbers. there are a bunch of line charts that show stats by date and it shows maximum number of dates it can. but i want it to show only last 8 dates. there is also a slicer which user can set which dates he/she wants to see the data, so any user can use that if it wants to see more data. but by default, most of the info is for last 8 dates and the chart shows like last 25 dates which is too much. i couldn't find the solution to this.

Labels (1)
2 Replies
Daryn
Creator
Creator

Hi,

I have only used Qlik Sense, not Qlik View, sorry. 

But could you use a bookmark/dynamic bookmark , does it have the same abilities?

https://www.youtube.com/watch?v=tFyqOigqnUw

Regards Daryn

RaviPuttaswamy5
Partner - Contributor III
Partner - Contributor III

you can use date filter in each expression for 8 weeks as below,   so by default it shows 8 weeks data.
=Date(WeekStart(max([Delivery Date])-63),'YYYY-MM-DD')