Assuming we had the following QlikView tables i the document:
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.
I think what you are suggesting is exactly what Stefan was suggesting. But you can't add the data in the section access, it has to be in the section application. if you want to keep state values that have existing orders, you will have to create dummy values for whatever your reduction field is to keep them in.
im assuming that I wouldnt have to create dummy orders (I can't do that.) I have a table that explicitly has states and one that has orders. So the way I set up the reduction table (above) wouldn't it reduce the orders for Joe, but still let him see the explicitly authorized states even if the are no orders for those?