Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jeevays7
Partner - Creator III
Partner - Creator III

Select date based on sheet navigation

Hi frds,

I have three sheets. (i.e. sheet1, sheet2, sheet3).

in sheet1 date selection is maximum date(13-12-2016) of the date field. if i go to sheet sheet2 the date should be one day before i.e (12-12-2016). then i go to sheet3 the date should be 13-12-2016.

the above action is only based on maximum date of the date filed selection. otherwise same date only selected all sheets.

that means in sheet1 the date is 12-12-2016, then it will same to sheet2 and sheet3.

how achieve this??

5 Replies
Gysbert_Wassenaar

Add a Select in Field action to the OnActivate Sheet trigger of the sheet and configure that action to select the wanted value in the relevant field. You can find the sheet triggers on the Triggers tab of the properties window of the sheet.


talk is cheap, supply exceeds demand
jeevays7
Partner - Creator III
Partner - Creator III
Author

Hi Gysbert,

Thanks for your reply gysbert.

but onActivate sheet trigger is not working when we see the document on browser right???

jonathandienst
Partner - Champion III
Partner - Champion III

I think it does, but its very simple to test, so I suggest you try it and see for yourself.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Gysbert_Wassenaar

Yes, that trigger does work in the ajax client too.


talk is cheap, supply exceeds demand
jeevays7
Partner - Creator III
Partner - Creator III
Author

Thank you gysbert,

Then any other solution for this??