2 Replies Latest reply: Dec 14, 2016 3:00 PM by Brian Yordnoff RSS

    Hide data elements based on Section Access

    Brian Yordnoff

      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.