Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

pradeepm
New Contributor II

Conditional show on Sheet

Hi,

I have to show one sheet for only some people, rest of the sheets can see everyone. Here i am using osuser() function in conditional show like: =

=if(OSUser()='user1' or OSUser()= 'user2' ,1,0). This is working fine, but i have to show this for 30 users and in future it may increase, how can i do this without section access?

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Conditional show on Sheet

Hi Pradeep,

Load user names from Excel file

LOAD

UserName

FROM ExcelFile;

=Len(Only({<UserName={'$(=OsUser())'}>} UserName)) > 0


Hope this helps you.


Regards,

Jagan.

View solution in original post

10 Replies
narband2778
Contributor II

Re: Conditional show on Sheet

Hi,

Use Mixmatch() function as shown below

=mixmatch(osuser(), 'user1','user2', 'user3')>0

regards,

Naresh

MVP & Luminary
MVP & Luminary

Re: Conditional show on Sheet

Hi Pradeep,

Try Match()

If(Match(OSUser(), 'user1', 'user2' , 'user3', 'user4', 'user5', .............'usern'),1,0)

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

pradeepm
New Contributor II

Re: Conditional show on Sheet

can we make usernames configurable?

i mean can we put all the usernames in one excel file and can we use the same in conditional show without writing all the usernames in condition?

pradeepm
New Contributor II

Re: Conditional show on Sheet

Hi Jagan,

can we make usernames configurable?

i mean can we put all the usernames in one excel file and can we use the same in conditional show without writing all the usernames in condition?

MVP & Luminary
MVP & Luminary

Re: Conditional show on Sheet

Hi Pradeep,

Load user names from Excel file

LOAD

UserName

FROM ExcelFile;

=Len(Only({<UserName={'$(=OsUser())'}>} UserName)) > 0


Hope this helps you.


Regards,

Jagan.

View solution in original post

dfoster9
Valued Contributor

Re: Conditional show on Sheet

This doc in the resource library

Sheets Security with Section Access

Is a very good reference for what you are trying to do. Basically you create a tick sheet for each user. If you aren't using section access then you will need to add the OsUser() calculation to set analysis in the sheet visibility.

MVP & Luminary
MVP & Luminary

Re: Conditional show on Sheet

Hi,

Check this link, hope it helps you.

Sheet level access

Regards,

Jagan.

amit_saini
Honored Contributor III

Re: Conditional show on Sheet

Pradeep,

Go to sheet properties-> condition and use this condition below:

OSUser() = 'ABC' or OSUser() = 'XYZ' or OSUser() = 'HJX'

Thanks,

AS

pradeepm
New Contributor II

Re: Conditional show on Sheet

It's Working,

Thank you