Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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')