0 Replies Latest reply: Jan 10, 2017 3:46 AM by Rajkumar A RSS

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

    Rajkumar A

      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.