topic Re: Section Access help in QlikView

Section Access help

hopkinsc — Thu, 21 Nov 2013 12:42:29 GMT

Hi All,

I am trying to get section access working by reducing the data by Sales person so they can see only their own sales but i want them to also see the overall sales so they can see their % of sales.

Can anyone help me to do this please?

Re: Section Access help

hopkinsc — Thu, 21 Nov 2013 15:47:15 GMT

Can anyone help please?

Re: Section Access help

jvitantonio — Thu, 21 Nov 2013 15:57:45 GMT

Hi,

I don't know your model, but if you go a such granular level, you won't be able to show overall sales. You can create a variable in your script that holds the sum of all sales and then use that, but this might not be useful if you are working with different markets.

BI Experience | A place to share our Business Intelligence experiences

Re: Section Access help

DavidFoster1 — Thu, 21 Nov 2013 15:58:39 GMT

I have not tried this, but you could create a aggregated 'total sales' value in the data model that all sales people have access to in addition to their own values. That way you have both their detail and a grand-total value available without the detail of other sales person activity.

Re: Section Access help

mikecrengland — Thu, 21 Nov 2013 16:52:53 GMT

I had the same needs on a couple of documents. I (kind of) solved it by creating 'hide prefix' fields that I set on open by using the OSUser() function and then locking them. It's not foolproof and definitely a work-around, but it's seemed to work so far. I wrote up a summary at Fortune Cookie BI: The Magic of the Princess Bride . (Pardon the random Princess Bride quotes; I do that so my designers will at least look at the posts).

If anyone has any thoughts/comments/criticisms I would love to hear them!