topic Hide Sheets in QlikView

Hide Sheets

Wed, 18 Aug 2010 10:16:59 GMT

Hello all,

I have discovered a lot of posts concerning " hide the sheets", but I don't see any solution for my problem:

I have implemented relatively easy a section access:

***

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN
USER, USER, USER
];
Section Application;

***

Then there is a shet "XY" which I want to hide:

I go to Sheet Properties / General Tab -->

"Show sheet" with the condition: (QvUser () = 'ADMIN')

After saving and perhaps reloading I start the application and enter my ADMIN credentials and I see the sheet.

When I log in with the user information it is the same. The sheet is visible.

What do i wrong?????

I have tested with the condition 1=2. This has worked the first time for me. After adjusting the section access, it doesn't work anymore.

Could someone please help m?!!

Thanks in advance

Regards Christoph

Hide Sheets

Wed, 18 Aug 2010 10:23:17 GMT

Hi Hasenclc

You can use OMIT for this purpose.

Example:

LOAD * INLINE [
ACCESS, USERID, PASSWORD, OMIT
ADMIN, ADMIN, ADMIN,
USER, USER, USER, <TableFieldName>
];

Then make a table including <TableFieldName> with the value "Yes".

Set Show Sheet -> Conditional to "<TableFieldName>='Yes'"

The sheet will thus only be shown to the people who dont have <TableFieldName> included in the inline load.

Hide Sheets

Wed, 18 Aug 2010 10:24:30 GMT

Hi,

What u do is pass one additional column "ShowSheet" to section access part where u have defined your users & give a value either 0 or 1 & on the sheet general tab put "ShowSheet" in the condtional box.

This can probably help.

Hide Sheets

Wed, 18 Aug 2010 11:58:42 GMT

Hello Santosh,

and with which command can I get the status of the ShowSheet in the conditional box?

Regards Christoph

Hide Sheets

Wed, 18 Aug 2010 12:21:49 GMT

Hi Christoph

Have you considered using Conditional show off sheets?

Right Click the sheet and in the "Show Sheet" settings you select "Conditional" - then you can do something like, if(CheckField=1) or similar.

/Martin

Hide Sheets

Wed, 18 Aug 2010 12:42:14 GMT

With each user one value for ShowSheet field(either 1 or 0) will come then sheet will be visible or hidden depending on value

Hide Sheets

Wed, 18 Aug 2010 12:54:49 GMT

Hello all,

thanks for your answers.

It is not so easy to follow you, so I will sumarize my way.

I have inserted additionally in script the "ShowSheet"

*****

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SHOWSHEET
ADMIN, ADMIN, ADMIN, 1
USER, USER, USER, 0
];
Section Application;

*****

So the admin has for Showsheet the number 1.

If I go to the conditions, how is my command?

=If (ShowSheet='1') OR

=(ShowSheet='1') OR what ?????

I am a little bit confused.

Hide Sheets

Wed, 18 Aug 2010 13:06:34 GMT

Hi Frederik,

your way I haven't tested yet.

Could you please give me some details concerning the table TabelField Name.

I think I am really a bit confused.

Thanks in advance

Regards Christoph

Hide Sheets

Wed, 18 Aug 2010 13:37:06 GMT


hasenclc wrote:Section Access;
LOAD * INLINE [
 ACCESS, USERID, PASSWORD, SHOWSHEET
 ADMIN, ADMIN, ADMIN, 1
 USER, USER, USER, 0
];
Section Application;

You can use the above script in section access and in the sheet conditional show property, add either of the following expressions:

SHOWSHEET=1

if(SHOWSHEET=1,true(),false())

This should resolve your issue.

Hide Sheets

Wed, 18 Aug 2010 14:23:13 GMT

Hello Haneesh,

thanks for your answer.

I have set up the same as you have proposed. If I login as USER and I check the status of "if(SHOWSHEET=1,true(),false())", it is false. .As Admin the status is displayed as true, so I think with the section access is everything ok.

Perhaps there are some other settings I have overseen? In the document settings? In the sheet settings??

regards Christoph

Hide Sheets

Anonymous — Wed, 18 Aug 2010 14:31:55 GMT

Christoph,
I'm sure that you've done it right the first tiem, and there was no need for addirional fields.
Take a look into the document security properties - the chances are you have "show all sheets and objects" checked. Uncheck it.

Hide Sheets

Wed, 18 Aug 2010 14:38:23 GMT

Thank you very much Michael, that's it. Now everything is fine.

Thanks to all other users, who have helped me.

Regards Christoph