1 Reply Latest reply: Sep 13, 2012 3:13 PM by Aaron Couron RSS

    Need help to load data using cross tables

      hi friends,

       

       

      can anybody helpmeout in resolving this issue

      Issue is

       

      I have a sample data as shown in figure which has two headers in the same source sheet as shown below

      1.jpg

      now i want the result in qlikview as below.. I want the last record to be updated for the time being and also let me know what i need to do if i would like to list all the records from 1 to 6 with the same order,target and delivery date populated in their corresponding columns instead of only the last record which is my current requirement now as displayed below in the image.

      2.jpg

       

      I thouth that a cross table can be used to get the above result ,im not sure ,kindly helpme out in getting this resolved.

       

      Kind Regards

      Anand.