14 Replies Latest reply: Feb 9, 2018 10:00 AM by Alessandro Marini RSS

    Section Access doesn't work Qlik Sense September 2017

    Alessandro Marini

      Good morning experts,

       

      I'm Alessandro.

      I have an issues with SA. Every time i try to access the file, sense turn to me an "Access Denied" error.  USERID is equal to Sense User name.

       

      Thanks in andvance,

      Alessandro

       

      PS the same SA works in QlikView

       

      section access;

       

      Accessi:

      load

      'USER' AS ACCESS

      ,upper(USERID) as USERID

      ,NTNAME as USER

      FROM [$(pathXLS)\Nuti.xls] (biff, embedded labels, table is Restrizioni$)

      where not isNull(NTNAME);

       

      concatenate (Accessi) load

      'ADMIN' as ACCESS

      ,upper(trim(subfield('$(RestrictionsSuperusers)', ','))) as USERID

      ,'*' as USER

      autogenerate 1;