Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to avoid reducing outer dimensions

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!

1 Reply
oknotsen
Honored Contributor III

Re: How to avoid reducing outer dimensions

Do not make the same topic more then once.

How to avoid reducing outer dimensions

May you live in interesting times!
Community Browser