Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sergio0592
Valued Contributor II

Issue with trigger on opening document

Hi all,

I'am facing an issue. So, i have two tabs with two fields as selection list : Year, Month.

What i'm trying to achive is when i open document current month must be selectionned in tab1 and previous month must be selected in tab2.

Is it possible to achieve this??

Thanks

1 Solution

Accepted Solutions
Partner
Partner

Re: Issue with trigger on opening document

You can add a trigger in each sheet.

Right Click in the tab -> Proprieties

Select Triggers -> Add Actions.

In firts tab you will select today, in second, today -1.

Look into the images.

5 Replies
mwoolf
Honored Contributor II

Re: Issue with trigger on opening document

On Open doc triggers don't work in ajax.

If you are using IE and the plugin, one way is to use alternate states.

If the app opens to the first tab, you could use onactivate for the second sheet to set the filter to the prev month.

shiveshsingh
Honored Contributor

Re: Issue with trigger on opening document

May be you can try Onsheet trigger for this.

isingh30
Valued Contributor

Re: Issue with trigger on opening document

Can you share your data or app?

Partner
Partner

Re: Issue with trigger on opening document

You can add a trigger in each sheet.

Right Click in the tab -> Proprieties

Select Triggers -> Add Actions.

In firts tab you will select today, in second, today -1.

Look into the images.

SNR1
Contributor

Re: Issue with trigger on opening document

HI Zilz, Could you please suggest how make default selection in list box with color as well. I have two list boxes with like below Source 1: (02/22 ver.) (03/22 ver.) (04/23 ver.) (05/23 ver.) (10/23 ver.)-->(prev year) Source2 : (02/22 ver.) (03/22 ver.) (04/23 ver.) (05/23 ver.) (06/23 ver.) (10/23 ver.)-->(prev year) I need default selection of source1 is (05/23 ver,) and source2 is (06/23) when ever I opened the qvw app above values needs to be selected by default. and once data updated new data versions are added to list box for list box1(source1) like (06/23) and listbx2(source2) is with (07/20) after updating the app I need above mentioned values as default. could you please suggest me Thanks In Advance