topic Re: display values for last 8 weeks by default in App Development

display values for last 8 weeks by default

mhghotbi — Thu, 22 Jun 2023 09:18:41 GMT

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.

Re: display values for last 8 weeks by default

Daryn — Thu, 22 Jun 2023 09:52:54 GMT

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

Re: display values for last 8 weeks by default

RaviPuttaswamy5 — Thu, 22 Jun 2023 14:54:47 GMT

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')