topic Qlikview Hyperlink to navigate between Sheets in QlikView

Qlikview Hyperlink to navigate between Sheets

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

HI,

I am new to this group and would like some help. Actually I am creating a Dashboard in Qlikview and I want to navigate between the sheets. I don't want to display Tabs. Please have a look on the attached screenshot. Like if I click on dashboard I can just view Dashboard only and if I click on Items sold link or hyperlink I can only saw sheet for items sold. Tabs should not visible. Please help. Thanks you

Re: Qlikview Hyperlink to navigate between Sheets

sasiparupudi1 — Sat, 05 Aug 2017 03:20:47 GMT

You have to use Conditional Show/hide using variables

Define variables with initial values as 0

vSummary

vItemsSold

VProfits

etc

Now, on each sheet properties, under general tab, select conditional show and stick the respective variables

on the buttons, add action with action type as external, set variable, select respective variable and set the condition

value as ex: Not vSummary

hth

Sasi

Re: Qlikview Hyperlink to navigate between Sheets

settu_periasamy — Sat, 05 Aug 2017 08:06:27 GMT

Hi,

There is an option to hide the tabs. 'Hide Tabrow' in the Document properties -> General Tab.

Then create a Text Box / Button, in the object properties -> Action -> Layout -> Activate Sheet -> "give the sheet object id"

Attached the Sample.

Re: Qlikview Hyperlink to navigate between Sheets

waqasshah — Mon, 07 Aug 2017 10:46:39 GMT

Dear Sasidhar Parupudi and Settu Periyasamy

Many thanks for your help. I got an idea and fixed my issue. Thanks