2 Replies Latest reply: May 21, 2013 5:31 AM by Raghav Kumar RSS

    For loop in the script

    Raghav Kumar

      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