Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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


0 Replies