Section Access

[andrefpc]

Hello community!

I have a doubt regarding Section Access. I have a QV app with data regarding sales and warehouse information.

I want to develop a section access for each salesman to view only their own sales but the warehouse information (which as no relation with salesman) must be visible for all users.

The first part (setting up section access for each salesman) is correct but, since there is no relation to salesman, the warehouse information is gone.

Any ideas?

Thanks in advance,

Andre

[vlad_komarov]

Andre,

You need to create REDUCTION field for Warehouse data as well and assign the '*' value for EVERY salesmen in your Section Access table...

Qlik supports multiple Reduction levels, so it should work well for you.

Regards,

Vlad

P.S. When applicable, please mark this answer Correct or Helpful.

[andrefpc]

Thanks for your answer Vladimir.

The reduction field is the Salesman Code, if I join/ concatenate it to the warehouse data it will change the warehouse values, am I right?

For example, for 10 salesman it will multiply my stock value by 10.

Sooooo confused

[andrefpc · Accepted solution]

Vladimir suggestion pointed me in the right track.

I've created a dummy salesman in the warehouse data, this way users can see their sales aswell as the warehouse data.

In section access, each salesman must be granted access to his own salesman code and to the dummy salesman.

[vlad_komarov]

Andre,

I've started writing a reply and saw that you've found a solution, but here is my suggestion also (since I am already writing it):

You are correct, you do not need to add a [Salesman Code] to your warehouse data..

Here is the example:

Section Access;

Security:

LOAD

  'USER' as ACCESS,

  upper("USERID") as USERID,

  SALESMAN_CODE as REDUCTION_C,

  WAREHOUSE_GROUP as REDUCTION_F,

  '' as OMIT

FROM [XXXXXXX]

;

And your Section Access table should look like:

Your warehouse table should look like this:

WH:

load

'WH' as WAREHOUSE_GROUP,

....

FROM [WWWWWW]

;

And your SalesPeople data load should be just like this:

SP:

load

SALESMAN_CODE,

.....

FROM [SSSSSS]

;

In the example above each user has an access to his/her own SALESMAN data and also to ALL records in WH table.

Regards,

Vlad