topic Re: For loop in the script in QlikView

For loop in the script

Tue, 21 May 2013 07:53:53 GMT

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.

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.

Thanks in advance.

Ragha

Anonymous — Tue, 21 May 2013 07:59:20 GMT

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;

Tue, 21 May 2013 09:31:38 GMT

Thanks Johannes.

Concepts on Join were not clear for me.

Thanks again.