1 Reply Latest reply: Sep 27, 2016 4:20 PM by Lakshmikandh Karthikeyan RSS

    Asking Tutorial Youtube for Dynamic data reduction on Qlik Sense

    Adhi Muljana

      Hi all,

      As my subject, I wish someone could give me the example on how I can utilize with a simple example for Dynamic data reduction.

       

      Here with my problem,

      I have an apps that could be access by 6 of our region managers (means 6 token user licenses), and each of them able to access to the data on their own region ONLY.

       

      I have tables:

      1. Sales Transaction, which is contain the data of sales transaction and the city_code included.

      2. Sales structure, which is contain the master of sales structure group where city_code is to be assign into an area_code. And area_code assign into a region_code.

      I figure the structure of sales would be like: National Sales - Region_Code - Area_Code - City_Code.

       

      How to arrange the data load (for table Sales Transaction) to be reduced into each Region_Code (as it will be one to one relation with Region Manager User ID)?

       

      I tried to search the solution and no result so far.

       

      Thanks for the help.