topic Trigger - select last possible month when activating sheet. in QlikView

Trigger - select last possible month when activating sheet.

retko1985 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

can someone advice how can I do this?

Thank you.

Re: Trigger - select last possible month when activating sheet.

sunny_talwar — Mon, 23 Apr 2018 13:54:17 GMT

last possible month based on the selection? based on today? based on max month in the dashboard? Also, what fields do you have in the dashboard? what are there format?

Re: Trigger - select last possible month when activating sheet.

jaumecf23 — Mon, 23 Apr 2018 14:01:08 GMT

Hi,

Go to the Sheet Propierties -> Triggers sheet -> Click the button "Add Action(s)" under On Active Sheet -> OK -> Introduce the field name of the month and the expression to obtain the needed month value.

Re: Trigger - select last possible month when activating sheet.

retko1985 — Mon, 23 Apr 2018 14:04:59 GMT

Hi,

field name is Month.

And I want last month that is loaded in the data. So If I have data loaded till January 2018, I want to select January.

Format - I used Month function on date field to get Month field.

Trying to use this, but its not working:

Thank you.

Re: Trigger - select last possible month when activating sheet.

sunny_talwar — Mon, 23 Apr 2018 14:07:47 GMT

First thing, I don't think you need single quotes around Month under Field

Second, by selection on Month, you will be selecting Months in 2010, 2011, 2012, .... 2018 (based on how many years you have)... is this what you want?

third, what is the format of the Month field? Is it 2, 3, 4 or is it Jan, Feb, Mar?

Re: Trigger - select last possible month when activating sheet.

Anonymous — Mon, 23 Apr 2018 14:11:06 GMT

Hi,

Did you try remove the single quotes of field?

If this not work, maybe the problem is the Month format.

Reggards,

Re: Trigger - select last possible month when activating sheet.

retko1985 — Mon, 23 Apr 2018 14:35:47 GMT

Actually I want last Year also, but I have Year locked to Always One Selected,

So it need to select last Year also.

Removing '' didnt work, still same.

Moth format is this:

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

Thanks

Re: Trigger - select last possible month when activating sheet.

sunny_talwar — Mon, 23 Apr 2018 14:38:48 GMT

So you have Year as always one selected and you want to select Multiple MonthYears? How is that going to happen? May be use alternate state?

Re: Trigger - select last possible month when activating sheet.

retko1985 — Mon, 23 Apr 2018 14:49:40 GMT

No, Year and Month Listboxes should switch to last available values in the dataset.

I will try to make an example QVW.

Re: Trigger - select last possible month when activating sheet.

retko1985 — Mon, 23 Apr 2018 15:21:40 GMT

Attaching the example:

So, when I switch to the Sheet1, it should select last Year and last Month available:

Thank you.

Re: Trigger - select last possible month when activating sheet.

sunny_talwar — Mon, 23 Apr 2018 15:23:55 GMT

So, you want to select Year = 2018 and Month = July? But you don't even have July-2018 in your dashboard? Did you mean to select March 2018?

Re: Trigger - select last possible month when activating sheet.

sunny_talwar — Mon, 23 Apr 2018 15:25:54 GMT

If March 2018 is what you want... then try these

Year

=Max({1}Year)

Month

=MaxString({<Year = {$(=Max({1}Year))}>}Month)

Re: Trigger - select last possible month when activating sheet.

retko1985 — Mon, 23 Apr 2018 15:31:44 GMT

You are right, its March, apologies ..

It works when I have no month selected, but it wont switch to last month if I have month already selected:

Now when I go back to Main a again to Sheet1, it stays the same.

Thank you.

Re: Trigger - select last possible month when activating sheet.

retko1985 — Mon, 23 Apr 2018 15:33:35 GMT

Adding 1 into Month Set analysis seems to work.. Thank you!!!

=MaxString({1<Year = {$(=Max({1}Year))}>}Month)

Re: Trigger - select last possible month when activating sheet.

sunny_talwar — Mon, 23 Apr 2018 15:33:52 GMT

Try this

=MaxString({1<Year = {$(=Max({1}Year))}>}Month)

Re: Trigger - select last possible month when activating sheet.

sunny_talwar — Mon, 23 Apr 2018 15:34:07 GMT

Hahahaha yes

Re: Trigger - select last possible month when activating sheet.

Glou — Fri, 07 May 2021 13:36:21 GMT

Hello,
I have to share as I just struggled with this ^^

If you have set MonthNames= like you do, 'Month' is now considerated by the select in field trigger as a text variable.
Therefore you have to recompose your month and get the text value with Text()
(it only works if you convert an actual month object, not the result as a number from 1 to 12)

=Text(Month(MakeDate(Max(Year), Max({<Month=>}Month),1)))