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: 
stekol61
Creator
Creator

Previous weeks on open

In my qvw i have the objects "YEAR", *MONTH", "YEARWEEK" and *DAY". "YEARWEEK" is e.g. '2018-01'.

When the qvw is opened i want to present data for the previous 4 weeks: E.g '2018-01', '2017-52', '2017-51' and '2017-50'

How do I do this?

25 Replies
stekol61
Creator
Creator
Author

Very strange.

I reloaded the app with Master Calendar enabled. After that I saved the app.

When I open it again it's still the same problem. No dates or week are filtered out

Frank_Hartmann
Master II
Master II

have a look at the attached qvw.

hope this helps

Frank_Hartmann
Master II
Master II

Or maybe like attached

hope this helps

stekol61
Creator
Creator
Author

Hi!

A little bit better.

However, I use a graph to present the data and when the app opens it should show the previous 4 weeks as default.

Then you should be able to use the master calender to select a different time period.

Not sure how to do this based on your example

Frank_Hartmann
Master II
Master II

i think this is what my app does.

So if you update your data next week my Straight Table will pick the Weeks 02-2018, 01-2018, 52-2017, 51-2017 automatically.

hope this helps

stekol61
Creator
Creator
Author

Hi!

But what dimention should I use in my graph to make this work?

Example belo uses 'YearWeek'

Frank_Hartmann
Master II
Master II

can u share this sample?

I suppose you need to use CalendarWeekAndYear as dimension instead of YearWeek

stekol61
Creator
Creator
Author

Here it is

Frank_Hartmann
Master II
Master II

So if i understood you correctly, your aim is to show the last 4 weeks by default.

But when your user selects e.g. 2017-50 then u want the graph to show 2017-50, 2017-49, 2017-48, 2017-47 ?????

stekol61
Creator
Creator
Author

Hi!

Last 4 weeks by default when app is opened.

After that the user should be able to select e.g.2017-50 and only see that week or Month:01+Year:2018 and see all weks in January 2018.