topic How to activate a hidden sheet by URL? in QlikView

How to activate a hidden sheet by URL?

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

All,

I try to use a url string to open one sheet(ex. sheet id is SH_201) of a document, and the tabrow is set to hidden in document properities. My url string is as..http://khbisqlikview/QvAJAXZfc/opendoc.htm?document=qvw%5Ctestreport.qvw&sheet=SH_201, but it didn't work. Is there any way to resolve this problem?

PS. If tabrow is set to display, the url string is o.k.!

Re: How to activate a hidden sheet by URL?

marcus_sommer — Thu, 04 Jan 2018 13:03:41 GMT

If you changed the visibility-condition for the sheet to something like:

= match(osuser(), 'YourUser', 'FurtherUser', ...)

it should work.

- Marcus

Re: How to activate a hidden sheet by URL?

erichuang — Fri, 05 Jan 2018 01:06:05 GMT

Hi Marcus,

Thanks for your reply! Could you give me more examples about your suggestions? Because I don't know where to insert the codes you said.

For avoiding gaps, I post my steps as the followings:

Step1. For my project, I must hide the tabrow.

Step2. I used ASP.net to make a url string(http://......&sheet=SH_201) to open a sheet in a document.As the below picture, the report should be opened in [Analysis] section, but it didn’t work.

Step3. If I uncheck [Hide Tabrow], and reopen the report with the same url string.

The url string worked and the document was opened in sheet 201(SH_201).

Re: How to activate a hidden sheet by URL?

marcus_sommer — Fri, 05 Jan 2018 07:43:16 GMT

The visibility conditions for the sheets will be handled within the sheet-properties in tab general:

- Marcus