0 Replies Latest reply: Sep 26, 2013 7:13 AM by Fredrik Wikberg RSS

    Grouping Question

    Fredrik Wikberg

      Hi

       

      I am quite new with Qlikview and have a grouping question. There is one thing I want to do but dont know how to script. I am thankfull for any help.

       

      I have a table that looks like the example below:

       

      OrderNoLineLineSuffixNamePO
      27671531139HQ 16.101479455
      27671531139HQ 16.101479457
      27671531239HQ 16.101479458
      27671531339HQ 16.101479459
      27671532139QR 10.101479460

       

      I want to group the PO row by the combination of OrderNo, Line och LineSuffix. So the table looks like to one below.

       

      OrderNoLineLineSuffixNamePO
      27671531139HQ 16.101479455, 1479457
      27671531239HQ 16.101479458
      27671531339HQ 16.101479459
      27671532139QR 10.101479460

       

      I dont really know which function to use and how to write the script to get that grouping function to work. Thanks for any help.