topic Re: How to hide object with login user? in QlikView

How to hide object with login user?

Mon, 26 Jan 2026 18:19:17 GMT

Good Afternoon!

I have a problem. I have 2 sheets, with different analyzes on a QVW, and I have some users who need see dashboard A with all information, other just see dashboard B and another both dashboards. So I created a button that activate this sheet and associated the users on conditional layout with this function: OSUser() = ‘ ID User’. It ‘s working, but now I have a greater number of user, and this method is difficult to manager. Is there another solution or function to hide object based on login user?

P.S: I tried use section access, but I don`t need hide one field, but all dashoard.

Some one can help me? Thanks

Re: How to hide object with login user?

Clever_Anjos — Wed, 13 May 2015 18:00:37 GMT

It would easier having a table (inline or excel file) with OSuser() and a flag

You expression would be = only(Flag) = 1

Re: How to hide object with login user?

Thu, 14 May 2015 16:51:09 GMT

Hi Clever!

The function not solved my problem, the sheet doesn’t hide. I would like to hide sheets when the user access the dashboard. For example: When I open the dashboard, my user is identified so hide or show the sheet.

Re: How to hide object with login user?

ramoncova06 — Thu, 14 May 2015 16:56:06 GMT

Talita, you can still use Clever solution, if you want to hide an specific object, you need to open the object properties, then go to layout and in conditional add his expression

another option is to hardcode the values with a nested if, something like if(UPPER(OSUSER()) = RAMON OR UPPER(OSUSER()) = TALITA,1,0)

Re: How to hide object with login user?

antoniotiman — Thu, 14 May 2015 17:15:26 GMT

Hi,

if You have many users and few profiles, You can create an Input Box (Profile A, B)

instead of Button.

The User selects Profile.

In Your conditional expression Hide/Show Profile='A' or Profile='B'.

Regards,

Antonio

Re: How to hide object with login user?

Thu, 14 May 2015 17:34:07 GMT

Ramon!

I have used function OSUser() on conditional layout, but a have a lot of number users and it's difficult to manager. Is there another solution?

Thanks