Hide data elements based on Section Access

[#1]

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.

[settu_periasamy]

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.

[#3]

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?