topic Re: Loop & Reduce to remove unwanted sheets or tabs in QlikView

Loop & Reduce to remove unwanted sheets or tabs

Sat, 07 Jan 2017 11:33:42 GMT

Suppose my dashboard has 6 tabs(sheets) and each user is given access to certain sheets only through section access. Say, users A can view only 1,3,6 numbered sheets while user B sees 1,4 numbered sheet only. Here, the sheets are just hidden on basis of Section access excel which we maintain for each sheet in the dashboard and assign a 1 or 0 for respective sheets.

Now, if we want to do the same using Loop & reduce, how can we do it? Instead of hiding the sheets, we want to remove the unwanted sheets from the child dashboards with respect to users.

PS:The userNTname field that we use to apply Section Access is not joined to any tables in the dashboard. Users cannot be categorized on basis of Location, Region,Department etc.

Thanks in advance.

Re: Loop & Reduce to remove unwanted sheets or tabs

marcus_sommer — Sat, 07 Jan 2017 12:24:16 GMT

AFAIK loop and reduce impact only the data within an application and not the GUI - therefore you couldn't remove sheets and objects with them. If you want to control which sheets are available for a certain user (which is strictly seen more a kind of usability and less a security feature) you could use a query to osuser() within the visibility-properties of the sheets.

- Marcus

Re: Loop & Reduce to remove unwanted sheets or tabs

vinieme12 — Sat, 07 Jan 2017 14:19:41 GMT

Keen to know what is the identified benefit (s) in comparison to hiding the sheets; even if this was possible?