topic Re: Section acess hide column data in QlikView

Section acess hide column data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I want to apply section access for the following scenario

I have following data

User,Country,dob

U1,USA,01/01/2017

U2,UK,20/01/2017

U3,SPAIN,21/02/2017

I need to display data as

When U1 logs in then following should be displayed

User,Country,dob

U1,USA,01/01/2017

U2,UK,***

U3,SPAIN,***

When U2 logs in then following should be displayed

User,Country,dob

U1,USA,***

U2,UK,20/01/2017

U3,SPAIN,***

When U2 logs in then following should be displayed

User,Country,dob

U1,USA,***

U2,UK,***

U3,SPAIN,***

Re: Section acess hide column data

eduardo_dimperio — Mon, 28 Aug 2017 12:49:16 GMT

Hi Amar,

Sorry but i didn't understand

When U2 logs in then following should be displayed

User,Country,dob

U1,USA,***

U2,UK,20/01/2017

U3,SPAIN,***

When U2 logs in then following should be displayed

User,Country,dob

U1,USA,***

U2,UK,***

U3,SPAIN,***

You want to same input different outputs?

Re: Section acess hide column data

Anonymous — Mon, 28 Aug 2017 18:17:55 GMT

Sorry my mistake.

I need to display data as

When U1 logs in then following should be displayed

User,Country,dob

U1,USA,01/01/2017

U2,UK,***

U3,SPAIN,***

When U2 logs in then following should be displayed

User,Country,dob

U1,USA,***

U2,UK,20/01/2017

U3,SPAIN,***

When U3 logs in then following should be displayed

User,Country,dob

U1,USA,***

U2,UK,***

U3,SPAIN,21/02/2017

Means the dob of other users should not be visible/marked as * for logged in user

Re: Section acess hide column data

eduardo_dimperio — Mon, 28 Aug 2017 18:59:42 GMT

Hi Amar,

You can do this, but QS only will recognize the user after you load the script.

let user= SubField(osuser(), 'UserId=',3); // Get the current user

U know how to work with "IF"?

Re: Section acess hide column data

Anonymous — Thu, 31 Aug 2017 03:03:09 GMT

Thanks. Is there any way to do this (hide data) at script level

Re: Section acess hide column data

Anil_Babu_Samineni — Thu, 31 Aug 2017 04:15:38 GMT

There is option called |Hidden script from Load preview. May be helps this?

Re: Section acess hide column data

eduardo_dimperio — Fri, 01 Sep 2017 17:13:17 GMT

You can create the same load inside a If.

If(User=A)then

Load Code A

endif

If(User=B)then

Load Code B

endif

If(User=B)then

Load Code B

endif

Re: Section acess hide column data

Anonymous — Sat, 02 Sep 2017 06:55:13 GMT

Thanks. But I have around 900+ users. Hence want to apply some logic along with Section Access to hide the data.

Please suggest

Re: Section acess hide column data

maxgro — Sat, 02 Sep 2017 14:28:05 GMT

don't think with section access, with section access you can hide data or fields (onit)

Dynamic data reduction ‒ QlikView‌

You can try in a chart

T3:

load * inline [

User,Country,dob

U1,USA,01/01/2017

U2,UK,20/01/2017

U3,SPAIN,21/02/2017

mydomain\myuser,ITALY,21/02/2017

];

Chart has 2 dimensions User and Country

and 1 expression

if(upper(OSUser())=upper(User), dob, '*****')

The expression is the same for all users

Re: Section acess hide column data

eduardo_dimperio — Mon, 04 Sep 2017 13:01:56 GMT

Ahhh ok

Try this:

Load

User,

Country

Dob

From

YouQVD

Store YourQVD

let user= SubField(osuser(), 'UserId=',3); // Get the current user

Load

User,

Country

If($user=User,Dob,'****') AS Dob

From

YourQVD

Re: Section acess hide column data

Anonymous — Mon, 04 Sep 2017 18:21:07 GMT

Thanks for reply.

I tried using osuser(), it works perfect on local machine, but when accessed from access point it gives some random value.

Please suggest.

Re: Section acess hide column data

eduardo_dimperio — Mon, 04 Sep 2017 21:32:02 GMT

Amar,

OSUser() get the NT user, try this subfield(OSUser(), '\', 2) and check if correspond to the user logged on NT

Re: Section acess hide column data

Anonymous — Tue, 05 Sep 2017 02:29:49 GMT

I have already checked subfield(OSUser(), '\', 2).

It gives random value.

Re: Section acess hide column data

Anil_Babu_Samineni — Tue, 05 Sep 2017 02:35:02 GMT

Have you tried Massimo solution?

Re: Section acess hide column data

Anil_Babu_Samineni — Tue, 05 Sep 2017 02:37:45 GMT

I assume, QvUser() instead OSUSER()

Re: Section acess hide column data

eduardo_dimperio — Tue, 05 Sep 2017 12:49:23 GMT

Hi Amar,

I agree with Anil. Try QvUser(), i read this post about it and this solution worked.

=QVuser() vriable doesn't return a username | Qlik Community

Using NTName in section access | Qlik Community

OSUser and NTNAME in Section Access