topic Re: 'Override' section access to get totals in QlikView

'Override' section access to get totals

Sat, 03 Dec 2011 20:26:22 GMT

I have an application that uses section access to limit users to see only the data for people that report to them. Is there a way to override that in certain conditions for provide overall averages so that they can compare their team to the overall department averages?

Re: 'Override' section access to get totals

swuehl — Sat, 03 Dec 2011 21:09:24 GMT

I believe section access will reduce data that you don't have rights to access on login, the data is really removed from the internal data model.

If you want to acces data after that point, you should not reduce it with section access. For example, you might keep a copy of overall averages in your data model, but reduce / remove only the more detailed data.

Is this something you want? Or how should your use case look like in more detail?

'Override' section access to get totals

Sat, 03 Dec 2011 21:14:30 GMT

I may have to revisit how I designed the application. It was so easy to just use section access to limit access to the agents' data. I have one of the keys as the agent id, so I would have to change things around to have the group average available.

Thanks for your help!

Re: 'Override' section access to get totals

swuehl — Sat, 03 Dec 2011 21:32:58 GMT

Maybe you could do that.

You could also use the login information using OSUser() or QVUser() to conditionally show objects / impact expressions. IMHO, that's not as secure and easy as section access, but probably more flexible.

Re: 'Override' section access to get totals

Sat, 03 Dec 2011 21:35:12 GMT

Here, secure is pretty important. I think I will publish the necessary averages in another way and stick with what I have so far.

There's always versin 2.0!

Thanks!

Re: 'Override' section access to get totals

ToniKautto — Sat, 03 Dec 2011 21:39:39 GMT

The only solution to your scenario is to do the calculations in the backend script, so that the values can be picked as precalculated results in to the frontend application. Besides solving your issue, this will also save you calculations in runtime which could be nice in bigger applications.

Without Section Access user might be able to create new object and thereby access data that you have not intended for them, so building your own access in expressions will probabaly not be very smooth.

Re: 'Override' section access to get totals

Sat, 03 Dec 2011 21:42:14 GMT

I'll take a look at that! That just might do the trick.

Re: 'Override' section access to get totals

Kumar9 — Fri, 17 Jan 2020 10:18:20 GMT

Hi, Interesting scenario and I also have the similar requirement. What if I dont want to do pre-calculation on overall average? Is it possible to get average on total after applying section access, i.e., getting rid of few calculations on section access.

Thanks for your help on this.