topic Re: Run one script as Administrator under Section Access in QlikView

Run one script as Administrator under Section Access

Thu, 21 Nov 2013 06:06:04 GMT

I have Section Access working successfully in my document, thus allowing users to see their own KPIs, say "Difference between Target Opportunities and Actual Opportunities" for themselves.

But on the dashboard, I want to show another KPI which is "Org. Wide difference Target Opportunities and Actual Opportunities" which I cannot calculate currently because Section Access is in place.

Looking at the data below, when A logs in, he should see his own KPI as 10 and Org. Wide KPI as 30

When B logs in, he should see his own KPI as 20 and Org. Wide KPI as 30.

Sales Agent	Target - Actual Opportunities
A	10
B	20
Total	30

Therefore, I want to create one variable that is not affected by Section Access, or rather assumes as if Administrator has logged in and has access to all the data.

Is this even possible?

Regards,
Sagar

Re: Run one script as Administrator under Section Access

Nicole-Smith — Thu, 21 Nov 2013 20:02:18 GMT

If you calculate the number and store the result in a variable in the script, you can use that variable to display the number to any of your users.

Re: Run one script as Administrator under Section Access

Thu, 21 Nov 2013 20:43:50 GMT

Another alternative: if you have multiple KPI values is... Load an Inline table in a suitable format Straight table or Matrix

Re: Run one script as Administrator under Section Access

Fri, 22 Nov 2013 05:09:39 GMT

Where should I calculate the number? In the database itself right?

Because I cannot calculate the number in my Qlikview application since Section Access script would have already run before any of the data is imported.

Re: Run one script as Administrator under Section Access

Nicole-Smith — Fri, 22 Nov 2013 13:33:08 GMT

You can calculate it in the QlikView load script. Section Access is only run once a user opens the document to view it. During the load script, you have all of the data.