Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dhavalvyas
Contributor III
Contributor III

Data Level Section Access

Hi,

I want data level restriction in object for particular sheet to particular user.

As in my application there is multiple sheets..out of which only for last sheet objects want to restrict data..?

how to achieve it..?

Thus for objects in sheet1 want to restrict data for CIF_REGION,IA_REGION and Region

Please do needfull..

1 Reply
Claudiu_Anghelescu
Specialist
Specialist

In the Excel instert also the 3 columns (CIF_REGION,IA_REGION and Region) with the restricted values for every user.

Then you can use this expression to show the restricted values for every Dimension.

=If(upper(OSUser())= USERID, Region)

=If(upper(OSUser())= USERID, CIF_REGION)

=If(upper(OSUser())= USERID, IA_REGION)

To help community find solutions, please don't forget to mark as correct.