Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Data Level Section Access


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

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.