topic Select date based on sheet navigation in QlikView

Select date based on sheet navigation

jeevays7 — Thu, 22 Dec 2016 06:42:04 GMT

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

Re: Select date based on sheet navigation

Gysbert_Wassenaar — Thu, 22 Dec 2016 06:47:04 GMT

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.

Re: Select date based on sheet navigation

jeevays7 — Fri, 23 Dec 2016 05:37:49 GMT

Hi Gysbert,

Thanks for your reply gysbert.

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

Re: Select date based on sheet navigation

jonathandienst — Fri, 23 Dec 2016 05:55:14 GMT

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

Re: Select date based on sheet navigation

Gysbert_Wassenaar — Fri, 23 Dec 2016 06:25:42 GMT

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

Re: Select date based on sheet navigation

jeevays7 — Fri, 23 Dec 2016 08:16:52 GMT

Thank you gysbert,

Then any other solution for this??