Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

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.

Qlikdashboard.jpg

Please provide my solution in Details or Steps to be done in QMC and in Sheet.

Community Browser