topic Re: Hide data elements based on Section Access in QlikView

Hide data elements based on Section Access

Mon, 26 Jan 2026 18:19:17 GMT

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.

Re: Hide data elements based on Section Access

settu_periasamy — Wed, 14 Dec 2016 18:46:06 GMT

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.

Re: Hide data elements based on Section Access

Wed, 14 Dec 2016 20:00:02 GMT

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?