Previous weeks on open

[stekol61]

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?

[mdmukramali]

Hi,

Stefan can you attach some sample data.

Thanks,

Mukram.

[stekol61]

Enclosed are some sample data

[mdmukramali]

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.

[stekol61]

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?

[mdmukramali]

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.

[stekol61]

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

[mdmukramali]

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?

[stekol61]

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.

[mdmukramali]

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.