topic Re: Hide sheets in QlikView

Hide sheets

Fri, 15 Aug 2014 10:39:39 GMT

How can i easily hide sheets in my app without any conditions. I want to hide these as we dont want to currently make these available to users.

Thanks

Re: Hide sheets

Colin-Albert — Fri, 15 Aug 2014 10:41:57 GMT

Set the Show Sheet as Conditional and set to zero

Re: Hide sheets

maleksafa — Fri, 15 Aug 2014 10:47:19 GMT

Under Properties of the sheet, General, Conditional set it to 0 or 1=2 like Colin said, but i prefer for example to set it conditional that only you can view it, by using the OSUser() function.

for example set the condition to: if (OSUser() = 'MALEK.SAFA,1,0) that way you will be the only one that is able to see the sheet.

Re: Hide sheets

Fri, 15 Aug 2014 10:47:34 GMT

thanks. To show it again would I use the document properties?

Re: Hide sheets

Fri, 15 Aug 2014 10:54:57 GMT

can you give me an example of osuser pls

Re: Hide sheets

maleksafa — Fri, 15 Aug 2014 11:03:08 GMT

under sheet properties, go to conditional and type the below for example

=if(OSUser() = 'CORP\BIUSER',1,0)

if the user is 'CORP\BIUSER' then it will be able to see the sheet, OSUser() takes the user name that you are accessing with, so in my case CORP is the corporate active directory name and BIUSER is the user (in my case it is the windows authentication user).

you can easily identify your OSUser(), by simply creating a text object in the dashboard with the expession =OSUser()

Re: Hide sheets

engishfaque — Fri, 15 Aug 2014 11:07:55 GMT

Dear Bshindroja,

Easiest way to hide and show the sheet.

Hide Sheet:

Sheet Properties > Tab General > Select Radio Box "Conditional" set value 0 > Apply > OK.

Show Sheet:

Settings > Document Properties > Tab Sheets > Select "Sheet" > Properties > General > Select Radio Box Always > Apply > OK.

Kind regards,

Ishfaque Ahmed