topic Issue with trigger on opening document in QlikView

Issue with trigger on opening document

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

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

Re: Issue with trigger on opening document

m_woolf — Thu, 08 Mar 2018 16:11:56 GMT

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.

Re: Issue with trigger on opening document

shiveshsingh — Thu, 08 Mar 2018 16:55:05 GMT

May be you can try Onsheet trigger for this.

Re: Issue with trigger on opening document

isingh30 — Thu, 08 Mar 2018 18:40:24 GMT

Can you share your data or app?

Re: Issue with trigger on opening document

cristianozilz — Thu, 08 Mar 2018 18:59:29 GMT

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.

Re: Issue with trigger on opening document

SNR1 — Fri, 13 Jul 2018 14:18:31 GMT

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