Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Let me try, thank you!
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
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...