topic Re: Regarding Section Access in QlikView

Regarding Section Access

Kiruthiga — Sat, 18 Feb 2023 20:48:39 GMT

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!

Re: Regarding Section Access

henrikalmen — Sat, 18 Feb 2023 20:39:23 GMT

Sure, use OMIT: https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm

Re: Regarding Section Access

Kiruthiga — Mon, 20 Feb 2023 02:57:23 GMT

Let me try, thank you!

Re: Regarding Section Access

Kiruthiga — Wed, 22 Feb 2023 19:10:40 GMT

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

Re: Regarding Section Access

henrikalmen — Wed, 22 Feb 2023 19:47:05 GMT

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/manage-security-with-section-access.htm