0 Replies Latest reply: Jul 25, 2012 10:12 AM by fdiazvega RSS

    Question about filtering rows in a Resident table using Crosstable

      Hello everyone,

       

      im relatively new to qlikview, and im having issues in a maintenance to a previous aplication in qlikview that reads from various excel files. It's a question in both ways, technical and to think the best way to solve this.

       

      It works by loading from excel files into a resident table like this.

       

      for each DirEmp in dirlist (Dir & '\*.')

              for each File in FileList (DirEmp & '\*.xls')

                  Set exist = 1;

                  T0:

                  Load

                     @1

                     @2

                     @3

                     etc..

            From [$(File)] ($(TipoXLS), no labels, table is [sheet1$(Signo)])

                                    where isnum($(@2)) and recno() <= 67;           

              next File

          next DirEmp  

       

       

      then making a crosstable into another resident table

       

      if (exist) then

            T1:

                CrossTable(idTipoM, Value,7)

                Load

           field1,

           field2,

           field3,

           etc..

      Resident T0;

      end if

       

      finaly i store all this in a .qvd

       

      Here is my problem.

       

      I need to calc an average of "Value" from T1, and in other cases to exclude a complete Row. I tryed to make a crosstable to another Resident T2 trying to delete this row, but i dont know exactly what row is N° 30 excel in .qvd file, plus it may need extra time to load data twice.

       

      Any advice will be helpful.

       

      Thank you so much in advance.

       

      Regards