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
