Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section access and Data Model related Issue

Dear Qlikis,

I have build a report for Sales and Stock for different group of users, using section access whom ever log-in to the system data will be reduced to given access and that is how data model is also designed.

now the challange is we want to see all the items from stock table in this sales and stock report. having said that we have also implemented Section Access on this application, when ever user login to the system, user/manager can see only those sales which belongs to them and so it will also reduce stock data (assosiative model).

my requirment is even though user login to the system we want to see all item stock in report irrespective of sales items.

appreciate your suggestion.

Gaurav.

4 Replies
Not applicable
Author

any wild guess !!

nstefaniuk
Creator III
Creator III

Hello.

You can:

- duplicate data and in the the duplicate lines remove sales information, then link to a standard code. Then give the standard code to all users in Section access. So a user will see HIS sales' data and ALL stock's data.

- change your model to separate sales and stock, sales are linked to a section access code on which you can apply section access, stock are linked to a standard code which is given to all users

- change your model to separate sales and stock in 2 distinct tables. Only the sales table has a section access. The 2 tables are linked on a key which is the concatenation of all dimension.

Not applicable
Author

Sorry for delay in reply, this will not work out as stock and sales has to be in one sigle report... but appriciate your response. many thanks

jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you attach the script.

Regards,

Jagan.