topic Re: Sheet Navigation in QlikView

Sheet Navigation

vardhancse — Wed, 12 Aug 2015 06:16:47 GMT

Hi Team,

I have one requirement is that.

I have one dashboard with below mentioned sheets

Home page

5 sheets in dashboard,

6th sheet was a help/glossary sheet.

If I open glossary sheet from Sheet_5 of a dashboard using a button action. Now I want a button in glossary sheet to go back to the Sheet_5 instead of home page.

Similarly for all the sheets, when ever I open Glossary sheet from one sheet in a dashboard. I should go back to that page only.

Re: Sheet Navigation

Anonymous — Wed, 12 Aug 2015 06:35:30 GMT

I would use a variable to determine from whichsheet I came

let's say you define a variable vPrevSheet

you are on Sheet 5 and you goto Sheet6 (glossary sheet)

you define a Trigger OnLeaveSheet and define vPrevSheet=5 (better take SheetId)

on Sheet 6 you define a button with Activate Sheet and give your variable vPrevSheet

on each Sheet you Need to define a onleavetrigger!

Re: Sheet Navigation

vardhancse — Wed, 12 Aug 2015 06:44:45 GMT

Hi,

Thanks for the reply, I am looking for the dynamic change of the said variable vPrevSheet.

So that from what ever sheet I went to Glossary I should come back to the same sheet.

Re: Sheet Navigation

Anonymous — Wed, 12 Aug 2015 06:45:54 GMT

Hi,

Please have a look:

Go to Previous Active Sheet

Hope it will helpful!!

Re: Sheet Navigation

Anonymous — Wed, 12 Aug 2015 06:47:42 GMT

I donot understand?

you are on Sheet 5 and onleavetrigger you define vPrevSheet = SheetID5

you are on Sheet 4 and onleavetrigger you define vPrevSheet = SheetID4

etc.

button onglossary sheet have Action activate sheet and give variable vPrevSheet and there you go

I implemented that solution for one of my customer and it works.

Re: Sheet Navigation

vardhancse — Wed, 12 Aug 2015 07:11:41 GMT

Okay let me try once and get back to you.

Re: Sheet Navigation

Wed, 12 Aug 2015 07:55:10 GMT

Hi,

Suppose you have two sheets with sheet id SH01 and SH02 respectively.

-In sheet properties, Select set onLeaveSheet trigger by setting a variable eg. vPrev with value 'Document\SH01' and do similar for different sheet id's in respective sheets.

-Create Button, set action for activate sheet and give sheet id as $(vPrev)

It will take you to previous active page.

Re: Sheet Navigation

kavita25 — Wed, 12 Aug 2015 08:03:04 GMT

Check the qvw

Re: Sheet Navigation

vardhancse — Wed, 12 Aug 2015 08:08:28 GMT

Same was mentiond above by Rudolf Linder

Re: Sheet Navigation

Anonymous — Wed, 12 Aug 2015 08:12:55 GMT

I cannot upload small example, so let me explain:

define your onleavetrigger: vPrevSheet with value "SH01" (first sheet)

same with yourother sheets

define your button with actionactivate sheet: =vPrevSheet

I have a new app with only 4 Sheets and it works.

where is your Problem? can you post sample app?

Re: Sheet Navigation

Wed, 12 Aug 2015 08:13:37 GMT

Sorry, i thought you're still stuck at same problem.

Re: Sheet Navigation

Anonymous — Wed, 09 Sep 2015 07:56:33 GMT

Hi Sasi.

Try this:

Create a variable (CTRL+ALT+V) called vReturnSheet
Also create variable called vShowHelpGlossary
Go to your help/glossary sheet
1. Make conditional show on Properties > General: vShowHelpGlossary = 1
2. Take notice on your ObjectID name in the help/glossary sheet!
3. Create button in the sheet and
  1. Add variable: vShowHelpGlossary with value 0
  2. Add an ActivateSheet (in the layout action type). SheetID is =vReturnSheet
Create a button on one of your 5 sheets
Go to button Properties > Actions
1. Add variable: vShowHelpGlossary with value 1
2. Add a second variable: vReturnSheet with value =Replace(GetActiveSheetId(),'Document\','')
3. Add an ActivateSheet. SheetID must be the same as noticed in no. 3b above
Copy the button to the other 4 sheets as a linked object

Now test and see that it all works ;o))

Best Regards,

Johnni Kirstein

Re: Sheet Navigation

sunilkumarqv — Wed, 09 Sep 2015 08:00:49 GMT

on glossary sheet Create a button - on actions Activate sheet -sheetID

Re: Sheet Navigation

Anonymous — Wed, 09 Sep 2015 09:02:24 GMT

When you have created the button, go to Properties > Actions

Add a variable from External > Set Variable. On the right set the Variable to "vShowHelpGlossary" and the Value to "0".

Then add another action from Layout > Activate Sheet. Again on the right set Sheet ID to "=vReturnSheet"

I hope this would help you,

Johnni