Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Not applicable

How to hide object with login user?

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

1 Solution

Accepted Solutions
ramoncova06
Valued Contributor III

Re: How to hide object with login user?

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)

5 Replies
Employee
Employee

Re: How to hide object with login user?

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

You expression would be = only(Flag) = 1

Not applicable

Re: How to hide object with login user?

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.

ramoncova06
Valued Contributor III

Re: How to hide object with login user?

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)

antoniotiman
Honored Contributor III

Re: How to hide object with login user?

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

Not applicable

Re: How to hide object with login user?

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

Community Browser