User Level security in application

[SatyaPaleti]

Hi Everyone,

We have a requirement. 

We have a users table which contains fields like Users, Department & Product. when ever user opens application only his related Department and Product only should display.

We are also having 5 to 6 tables and all the tables have Department and Product field and we have developed data model according to the requirement. 

So when ever user opens application only his related Department and Product  should be display.

For example I am having

User             Department               Product
Mike             Electronics                Mobile

                                                              Laptop

                                                              CPU
Alex              Automobile             Bumper

                                                            Gear Rods

                                                             Bolts

If the User Mike login to application then he have to see related Department & Product  values only.

This Department & Product values are not static. these are dynamic. in dev environment we will have different departments & Products. In Test environment we will have different Department & Products. We need to achieve dynamically.

Can some one help how to achieve this? or else can share any related article regarding this scenario

Thanks,

Satya 

[SatyaPaleti]

Hi Friends,

Is there any chance to achieve this ?

[AshutoshBhumkar]

Hi,

You can use section access for data reduction based on the columns and data specified in Section Access table.

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/man...

Thanks,

Ashutosh