topic Re: Go to last visited sheet button in QlikView

Go to last visited sheet button

Fri, 15 May 2015 11:03:55 GMT

Hi Experts,

I am trying to create a button/text object which on clicking will take me to my last visited sheet (and not the previous sheet in the qvw).

Any help regarding this will be highly appreciated.

Thanks in advance.

Regards,

Nayana

Re: Go to last visited sheet button

Fri, 15 May 2015 11:08:56 GMT

Hi Nayana,

are you moving between sheets via the tabrow or from actions?

if from actions you can add an action to capture the current sheet ID when you click to move sheet, you can then recall that same variable to use in activating your prior sheet

hope that helps

Joe

Re: Go to last visited sheet button

Fri, 15 May 2015 11:36:39 GMT

Hi Nayana,

I have tested your qvw. It does not function correctly.

i went to sheet 4 then went to 2. click on prior i landed on sheet 3. which is incorrect.

Re: Go to last visited sheet button

Fri, 15 May 2015 11:43:16 GMT

Just did exactly as you described with no problems

Re: Go to last visited sheet button

Fri, 15 May 2015 11:47:18 GMT

Try not to do this not with text boxes but with tabrow.

Re: Go to last visited sheet button

Fri, 15 May 2015 11:53:41 GMT

Its not designed to work via tabrow, I simply kept that showing so you could see the moving between the tabs.

I've adjusted and hidden the tabrow now instead

Re: Go to last visited sheet button

Fri, 15 May 2015 12:44:34 GMT

did a sample .qvw file.

works with going throwgh pages via tabrows.

just 2 variables used.

Re: Go to last visited sheet button

Fri, 15 May 2015 14:47:52 GMT

This worked. Thanks a lot.