topic Re: Help in QlikView

Help

panipat1990 — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I am New In Qlikview..I want to Know About Loop(For loop)......With Example...Qvw File.......Where We Use For Loop...And Why We Use.....What Is Reason Behind It For Using Loop........How Would I know That I am Use LOOP........With Example

Re: Help

MayilVahanan — Wed, 22 Jul 2015 08:15:46 GMT

Please refer

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

Re: Help

alexandros17 — Wed, 22 Jul 2015 08:16:34 GMT

there could be lots of reasons to have a loop, the logic is to reiterate an operation more than one time, in the following example I have to concatenate files into one table doing some check

let path_Alles = '..\Allestimenti\pagella_cliente_Allestimenti_*.xlsx';
for each File in filelist (path_Alles)
IF(left(right(File,11),4)<=$(currYear)) then
PalletInfo:
LOAD
'PalletInfo' as TableOrig,
if(Len([Reference Client])<>10, Repeat('0',10-Len([Reference Client])) & [Reference Client],[Reference Client]) as shipto_code,
'PALLET' as type,
Upper(Trim(Subsubcategory)) as competitor,
[WEEK UPDATE] as dataAlles,
[sold to] as customer_code,
[Allestimenti Samsung: Quantità] as palletinfo_qty,
'-' as pallet_material,
0 as palletinfo_prezzo,
'-' as palletinfo_serie,
'1' as datoAssoluto
FROM $(File) (ooxml, embedded labels, table is Display)
Where [WEEK UPDATE] >= 201223 and [WEEK UPDATE] <= 201240 and [Product (short)] = 'PALLET';
ENDIF
next File

Re: Help

jagan — Wed, 22 Jul 2015 09:41:20 GMT

Hi,

Check this link for sample for loop

Load Multiple excel sheets using For loop

Regards,

Jagan.