7 Replies Latest reply: Oct 23, 2013 6:01 PM by Oscar Marquez RSS

    Test section access in desktop?

    Oscar Marquez

      Is it possible to test section access code in desktop? I'm not the admin of the server and sometimes it's very annoying asking It to reload for every change I do I'd like to be able to try it in desktop but doesn't seem to be working...

       

      Here's what I have

       

      SECTION ACCESS;

      LOAD upper(ACCESS) as ACCESS,

           upper(NTNAME) as NTNAME,

           upper(REGION) as REGION

      FROM

      [http://XXXXXXXXXXXXXXXXXXX/teams/QlikViewSCO/Repository/360Dashboard/SMCWQVData.xlsx]

      (ooxml, embedded labels, table is AL);

       

      and in the xlsx file:

      ACCESSNTNAMEREGION
      adminamericas\marquoscAMS

       

      But I'm able to see all data...

       

      Thanks in advance for your help!