Regarding Section Access

[Kiruthiga]

Hello Friends, 

I appreciate your time. I am looking for a solution for the scenario below., Could you please reply if you have any suggestions. Thank you!

We have a Qlik Sense application and it’s currently accessed by all the vendors with no reduction. There is a new requirement with 2 new fields say avgprice and margin are getting added to the application. Now all the vendors will see everything  but only their avgprice and margin.  Can we apply reduction to only 2 fields and leave rest of the columns with out reduction? Appreciate your response.

For example,

Demo:

Load * inline [ 

Vendor, Product, Sales, Avgprice,Margin

VendorA, P1, 10$,2.5$,2%
VendorB,P2,20$,5$,1%
VendorC,P3,30$,3$,3%
];

let’s say if a VendorA login he will see something like below

Vendor,Product,Sales,Avgprice,Margin

VendorA,P1,10$,2.5$,2%
VendorB,P2,20$,-,-

VendorC,P3,30$,-,-

Thank you!

[henrikalmen]

Sure, use OMIT: https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/m...

[Kiruthiga]

Let me try, thank you!

[Kiruthiga]

Omit hides the column completely from the users  but I would like to show the users their own margin and prize but rest of the fields shouldn’t get reduced., thank you 

[henrikalmen]

Apparently I read your question too fast. I don’t know if the avgprice and margin fields are calculated or if they are static in the table, but what you probably need to do is to separate those columns - or the data that’s needed to calculate them - into a separate table and then use reduction fields in section access to reduce all rows except for the ones the user is allowed to see  

See “managing access to row level data” in the documentation. https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/m...