topic Re: Previous weeks on open in QlikView

Previous weeks on open

stekol61 — Wed, 03 Jan 2018 09:31:58 GMT

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?

Re: Previous weeks on open

mdmukramali — Wed, 03 Jan 2018 11:07:45 GMT

Hi,

Stefan can you attach some sample data.

Thanks,

Mukram.

Re: Previous weeks on open

stekol61 — Wed, 03 Jan 2018 11:41:48 GMT

Enclosed are some sample data

Re: Previous weeks on open

mdmukramali — Thu, 04 Jan 2018 05:34:01 GMT

Hi Stefan,

You have a Date field in your data so based on Date you can Select the last 4 Weeks when you open QlikView Application.

Goto Document Properties --> Trigger -->Onopen --> Add Action --> Select in Field--> Field Date

Search String -->

= '>' & Date(Weekstart(Max(Date))-21, 'YYYY-MM-DD') & '<=' & Date(Max(Date), 'YYYY-MM-DD')

Kindly find the attached application for your reference.

Thanks,

Mukram.

Re: Previous weeks on open

stekol61 — Thu, 04 Jan 2018 08:48:41 GMT

Hi!

When using a master calender (as used in my app) or a filer for Year and Month the trigger doesn't work.

Any idea how this can be solved?

Re: Previous weeks on open

mdmukramali — Thu, 04 Jan 2018 08:58:33 GMT

Hi Stefan,

I didn't understand filter for Year and Month the trigger doesn't work?

you mean you want to see the last 4 Weeks Data in the Stright table even on the selection of filters?

Thanks,

Mukram.

Re: Previous weeks on open

stekol61 — Thu, 04 Jan 2018 09:05:25 GMT

Hi!

My original app uses a Master Calender.

What I'm looking for is that when the app opens it should show the previous 4 weeks as default.

The user can then use the Master Calender.to select a different time period

Re: Previous weeks on open

mdmukramali — Thu, 04 Jan 2018 09:31:51 GMT

Hi,

if you are using Master Calendar then also same trigger should work .

can you tell me :

what is the MaxDate in your Master Calendar?

Re: Previous weeks on open

stekol61 — Thu, 04 Jan 2018 09:37:25 GMT

Hi!

Not sure about MaxDate. I have not developed this Master Calendar.

However, without using Master Calendar and only use e.g. 'Year' and 'Month' filter the trigger doesn't work.

As you see in my previous enclosed app the Master Calendar is disabled.

Re: Previous weeks on open

mdmukramali — Thu, 04 Jan 2018 09:47:54 GMT

Hi,

In the Previous enclosed app the Master Calendar in working it's not disabled.

we have applied the trigger on Date Field so it's selected those dates which belong to last 4 weeks and remaining dates are in grey color because which do not belong to those 4 weeks.

like that only 2017-Dec and 2018-Jan are under those 4 Weeks so those are possible values remaining are not associated with those Weeks.

Re: Previous weeks on open

stekol61 — Thu, 04 Jan 2018 10:04:17 GMT

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

Re: Previous weeks on open

Frank_Hartmann — Thu, 04 Jan 2018 10:31:29 GMT

have a look at the attached qvw.

hope this helps

Re: Previous weeks on open

Frank_Hartmann — Thu, 04 Jan 2018 10:49:40 GMT

Or maybe like attached

hope this helps

Re: Previous weeks on open

stekol61 — Thu, 04 Jan 2018 11:48:55 GMT

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

Re: Previous weeks on open

Frank_Hartmann — Thu, 04 Jan 2018 11:56:58 GMT

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

Re: Previous weeks on open

stekol61 — Thu, 04 Jan 2018 12:10:31 GMT

Hi!

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

Example belo uses 'YearWeek'

Re: Previous weeks on open

Frank_Hartmann — Thu, 04 Jan 2018 12:18:58 GMT

can u share this sample?

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

Re: Previous weeks on open

stekol61 — Thu, 04 Jan 2018 12:22:17 GMT

Here it is

Re: Previous weeks on open

Frank_Hartmann — Thu, 04 Jan 2018 12:32:40 GMT

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 ?????

Re: Previous weeks on open

stekol61 — Thu, 04 Jan 2018 12:38:22 GMT

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.