Security definitions cannot be dependent on Sheets, so it would be impossible to implement exactly what you are asking for. You can look for possible work-around solutions.
It's important to understand that the data is either reduced (for all sheets) or it's not reduced at all. Possible solutions:
- Split your application into two. Sheets 1-4 in App #1 would not require any data reduction, while Sheets 5-8 in App #2 would be implemented with data reduction
- build your data model in such a way that the data elements that are used in sheets 1-4, are associated with all employees, while the data elements that are used in sheets 5-8, are only associated with individual employees. This way, data reduction could only impact the data that's used in sheets 5-8.
Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!
section access in a way that all 4 users will be able to see all data of first 4 sheets. but the data should get reduced in other four sheets for example:
That's not possible. There is only one data model for the entire document. All objects on all sheets use the same data model. So it is not possible to reduce the date model only for some part of the document with section access. You will have to use set analysis expressions and make sure the user cannot create or modify objects.
Hi Gysbert, thanks for your response can you let me know how can I mention these things in set analysis.
coz as mentioned by oleg & henry I am having only one data model and the filters can be same in all the 8 sheets. so can you give me the possible way out how can I restrict the things with the help of section access and set analysis.
If licensing is not an issue then create 2 apps.
I have a assumption that page 1-4 are summary and 5-8 are detail for the same.
Had a similar situation , so created a summary data model also and concatenate with main data model.
Ex: say you key is region i,e. east west north and south.
in the summary data model make region as nation.
Define section access for person 1 as nation and north, person 2 as nation and south and so on.
In sheet 1-4 use set analysis to display only "nation" region
and in sheet 5-8 use set analysis to display anything not belonging to region "nation".