Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

For loop in the script

Hi all..

I am quite inexperienced with using qlikview.

I have been trying to use 3 FOR loops. But am unable to get the syntax right.

Any help with the code would be very helpful.

I have 3 input data tables.

WHHandling_WH
WH1100
WH2200

CityHandling_city
C110
C220

PlantHandling_plant
P11,000
P22,000

I am looking for creating a table this way. For each plant, for each WH, all Cities are to be taken and the Total needs to be calculated.

PlantWHCityHandling_plantHandling_WHHandling_cityTotal_Handling
P1WH1C11,000100101,110
P1WH1C21,000100201,120
P1WH2C11,000200101,210
P1WH2C21,000200201,220
P2WH1C12,000100102,110
P2WH1C22,000100202,120
P2WH2C12,000200102,210
P2WH2C22,000200202,220

Thanks in advance.

Ragha

1 Solution

Accepted Solutions
jsn
Honored Contributor

Re: For loop in the script

Hi Ragha,

You should be able to do:

Table1:

Load

     *

From Table1.xyz

join

Load

     *

From Table2.xyz

join

Load

     *

From Table3.xyz

FinalTable:

Load

     *,

     Handling_plant + Handling_WH + Handling_city as Total_Handling

Resident Table1;

Drop table 1;

2 Replies
jsn
Honored Contributor

Re: For loop in the script

Hi Ragha,

You should be able to do:

Table1:

Load

     *

From Table1.xyz

join

Load

     *

From Table2.xyz

join

Load

     *

From Table3.xyz

FinalTable:

Load

     *,

     Handling_plant + Handling_WH + Handling_city as Total_Handling

Resident Table1;

Drop table 1;

Not applicable

Re: For loop in the script

Thanks Johannes.

Concepts on Join were not clear for me.

Thanks again.

Community Browser