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: 
sergio0592
Specialist III
Specialist III

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
cristianozilz
Partner - Contributor III
Partner - Contributor III

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.

View solution in original post

5 Replies
m_woolf
Master II
Master II

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

May be you can try Onsheet trigger for this.

isingh30
Specialist
Specialist

Can you share your data or app?

cristianozilz
Partner - Contributor III
Partner - Contributor III

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

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