topic Re: Conditional show on Sheet in QlikView

Conditional show on Sheet

Anonymous — Mon, 01 Sep 2014 09:48:16 GMT

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?

Re: Conditional show on Sheet

narband2778 — Mon, 01 Sep 2014 09:54:02 GMT

Hi,

Use Mixmatch() function as shown below

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

regards,

Naresh

Re: Conditional show on Sheet

jagan — Mon, 01 Sep 2014 09:54:23 GMT

Hi Pradeep,

Try Match()

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

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Conditional show on Sheet

Anonymous — Mon, 01 Sep 2014 09:58:14 GMT

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?

Re: Conditional show on Sheet

Anonymous — Mon, 01 Sep 2014 09:59:03 GMT

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?

Conditional show on Sheet

Re: Conditional show on Sheet

jagan — Mon, 01 Sep 2014 10:03:28 GMT

Hi Pradeep,

Load user names from Excel file

LOAD

UserName

FROM ExcelFile;

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

Hope this helps you.

Regards,

Jagan.

Re: Conditional show on Sheet

DavidFoster1 — Mon, 01 Sep 2014 10:09:17 GMT

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.

Re: Conditional show on Sheet

jagan — Mon, 01 Sep 2014 10:10:47 GMT

Hi,

Check this link, hope it helps you.

Sheet level access

Regards,

Jagan.

Re: Conditional show on Sheet

amit_saini — Mon, 01 Sep 2014 10:17:54 GMT

Pradeep,

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

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

Thanks,

Re: Conditional show on Sheet

Anonymous — Mon, 01 Sep 2014 10:20:13 GMT

It's Working,

Thank you

Re: Conditional show on Sheet

vijay_iitkgp — Mon, 01 Sep 2014 10:26:20 GMT

Hi Pradeep,

You must have Users information stored somewhere in table/ qvd/excel. You can cretae one table in application with concatenated field (0say User) of all users which you want to give access and then use expression

Substringcount(OSUser,User)>0

Ex:

If you have table

UserList:

UserName

From XYZ.qvd;

Load

Concat(UserName) As UserName

From XYZ.qvd;

Hope this help.