Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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