6 Replies Latest reply: Mar 21, 2016 12:22 PM by Alberto Peres RSS

    Crosstable and where

    Alberto Peres

      Hi,

      I made a crosstable of a csv file, now should I apply a where clause to exclude some lines, why Qlik did not leave it? how can you fix this?


      This is the frame of script:

       

      FOR Each file in FileList('..\..\IMPORT\MOVIMENTI\ORE\MENSILE\New\*.csv')

        CrossTable(C_CAUSALI, W_ORE_TOTALI, 7)

        ORE_T:

        LOAD text(mid(FileBaseName(),1,3)) AS C_AZIENDA,

        text(SubField(FileBaseName(), ' ', 3)) AS ANNO,

        FileName() AS FILENAME,

        *

        FROM $(file) (txt, codepage is 1252, embedded labels, delimiter is ';', msq, header is 2 lines);

       

       

      NEXT file;

       

      Thank you in advance.