Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My QlikView 11.2 app pulls invoice data from a single table. Some columns might be
Location
Product Line
Customer
Item
Invoice Date
Sales Amount
Cost Amount
Margin Percent
So a line might look like:
Baltimore | 1100 | Acme | Widget | 2016-12-01 | 110.50 | 60.00 | 0.457
We currently have section access mapping certain users to certain locations, and this work well.
We have an additional requirement now to restrict certain users from seeing the Cost and Margin values on any/all data they have access to. I'd rather not build this into the tables and other QlikView objects if I can help it. Is there a way to "zero out" these columns in the extract file for certain users based on section access? If not, what's the best overall approach?
Thank you.
Hi,
if the users list are less, you can try like in the data model,
if(MixMatch(OSUser(),'OSusername1','OSUsername2',etc..),0,Cost) as Cost,
if(MixMatch(OSUser(),'OSusername1','OSUsername2',etc..),0,Margin) as Margin,
not sure, this is good approach, but one way to do it.
Thank you. That won't work because at script execute time, the user is not known.
I think I'm going about this the wrong way. I'm looking at the OMIT feature now. Will that work on multiple fields?