topic Re: Open Specific Sheet in QlikView

Open Specific Sheet

machammarj — Wed, 09 Nov 2016 13:44:23 GMT

Hi Josh,

Could you please help me ?

I am just trying to open specific sheets from the same document.

It just opens the last one.

What do I have to check please?

Re: Open Specific Sheet

Josh_Good — Wed, 09 Nov 2016 15:42:12 GMT

Hi Marcos,

You can use the action "Activate Sheet" under "Layout". You will need to get the Sheet ID for the sheet you want to go to from the sheet properties.

-Josh

Qlik

Re: Open Specific Sheet

ganeshreddy — Tue, 04 Sep 2018 13:54:07 GMT

Hi jgd‌

I have a scenario that if one of the specified value from the URL is missing the access point should not show the dashboard, at the moment access point is showing the the dashboard for possible value.PFB example

&select=LB01,Germany,USA

I have USA in the data for the given list box but not Germany, business user asking us to display nothing if any of the value is missing from the list box. Could you suggest how to handle this scenario.

Thanks in advance,

Ganesh

Re: Open Specific Sheet

Josh_Good — Tue, 04 Sep 2018 14:11:30 GMT

Hi Ganesh,

I can't think of a way to do this off the top of my head, but I"m sure someone more skilled than me would have thoughts. I recommend you start a new thread with the question so you can get the brainpower of the entire community working for you.

Josh

Qlik

Re: Open Specific Sheet

ganeshreddy — Tue, 04 Sep 2018 14:19:21 GMT

Thank you Josh opened a new thread Passing parameter to access point URL

Re: Open Specific Sheet

manoj217 — Tue, 04 Sep 2018 14:29:04 GMT

if you want to select pervious sheet which you opened means

go for the actions and select activate previous sheet