2 Replies Latest reply: Feb 14, 2018 6:01 AM by Tresesco B RSS

    Section access and where clause

    Antonio Forino

      Hi,

      i build my security matrix on excel - the goal is to have just one excel for several application

       

      SECTION ACCESS;


      LOAD


          APPLICATION,

          ACCESS,

          NTNAME,

          SECURITYFIELD


      FROM [\\seme004\EMEA\Transversal\JDE Support\QV.QlikView\SecurityMatrix.xlsx](ooxml, embedded labels, table is SecurityMatrix) WHERE (APPLICATION='Securities') ;



      On the where condition i would like to specify the application (in the example i'm loading just securiities for the application called "Securities"). The issue is that when the where clause is specified no lines is fetched.

      I assume is because i'm using SECTION ACCESS that doens't allow to use where clause. I'm correct? How this can be build then?

      Thank you