18 Replies Latest reply: Jun 2, 2016 3:30 PM by Peter Cammaert RSS

    How to avoid reducing outer dimensions

    Leslie Blumenfeld

      Assuming we had the following QlikView tables i the document:

       

      Orders

           Order Number

           State

       

      States

           State

           Country

       

      with contents:

       

      Orders

           1     NY

           2     NY

           3     FL

           4     OH

       

      State

           NY     USA

           FL     USA

           OH     USA

       

      I'll do Section Access and reduce on Order Number. Suppose a specific user is only authorized to Order 3 & 4. In addition to the data in Orders being reduces to 3 & 4, the data in State will be reduced to only FL and OH.

       

      How do I do the reduction, but specify that I don't want the data in table State to be reduced? I would still want other connected tables to be reduced.

       

      Any ideas?

       

      Thanks!