Section Access (Dynamic Data Reduction) Limit the data based on user
Hi QliksenseExperts,
Here is my question I’m struggling and couldn't able to find the solution by myself in QLIKSENSE.
Office
Year
Income
Office1
2010
1000
Office2
2010
900
Office3
2010
700
Office4
2010
750
Office5
2010
800
Office1
2011
900
Office2
2011
600
Office3
2011
800
Office4
2011
700
Office5
2011
700
Office1
2012
800
Office2
2012
500
Office3
2012
500
Office4
2012
900
Office5
2012
800
Above is my table structure in sql server. I would like to create a secession Access for data reduction using qliksense and QMC. I have ADMIN rights to access HUB and QMC.
Requirement:
I have sample user like (user1, user2, user3, user4 and user5)
I want to limit the data based on the user and office
Eg:
If user1 login only Office1 to displayed to him
If user2 login only Office2 to displayed to him
If user3 login only Office3 to displayed to him
If user4 login only Office4 to displayed to him
If user5 login all offices displayed to him
Note : Iam using Office field in my Filter according to user this filter should limit the whole app or sheet data.
Please provide my solution in Details or Steps to be done in QMC and in Sheet.