24 Replies Latest reply: Apr 9, 2018 8:15 AM by David Štorek RSS

    Section access is not working as expected : Need help

    DILIP SOLANKI

      Hi All,

       

      I am new to section access in Qlik sense.

       

      I have following 3 tables with sample data:

       

      Geo Table

      GeoNameDocumentStatusSales
      IndiaCompleted1400 INR
      USAIncomplete2000 INR
      CanadaCompleted4500 INR
      ANZCompleted1500 INR
      RussiaIncomplete2500 INR

       

      Zone Table

      ZoneNameDocumentStatusSales
      SouthCompleted1400 INR
      NorthIncomplete2000 INR
      EastCompleted4500 INR
      WestCompleted1500 INR
      CentralIncomplete2500 INR

       

      Country Table

      CountryNameDocumentStatusSales
      IndiaCompleted1400 INR
      USAIncomplete2000 INR
      CanadaCompleted4500 INR
      AustraliaCompleted1500 INR
      UKIncomplete2500 INR

       

      Now I am showing these table information on map through geo-analytics as below.

       

      GeoMap.PNG

       

      Now when anyone logged on Qlik sense, then only logged in user associated records should get display.

      e.g. Permission Matrix is as below:

       

      UserNamePermissionTypeValue
      dir\jeevaGeoIndia
      dir\jeevaGeoCanada
      dir\prasadZoneSouth
      dir\prasadCountryIndia

       

       

      As per above matrix when JEEVA logged in the qlik sense, he should see Geo (India and Canada), he should not see other geo, zone or countries.

       

      My Section access query is as below:

       

      SECTION ACCESS;

      LOAD * INLINE

      [

           ACCESS, NTNAME, GROUP, GEONAME

           USER, DIR\PRASAD, *, INDIA

           USER, DIR\JEEVA, *, INDIA

      ];

       

       

       

      But when JEEVA is not logged in the Qlik sene, he is getting ACCESS DENIED issue.

       

      Can anyone help me with this issue, might I am doing something wrong with section access script.

       

      Thanks

      Dilip Solanki