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!
