Section Access (Dynamic Data Reduction) Limit the data based on user

[#1]

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.