Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.