Question about filtering rows in a Resident table using Crosstable

Tue, 24 Jul 2012 21:18:24 GMT

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

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

topic Question about filtering rows in a Resident table using Crosstable in QlikView

Question about filtering rows in a Resident table using Crosstable