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:
OrderNo | Line | LineSuffix | Name | PO |
2767153 | 1 | 1 | 39HQ 16.10 | 1479455 |
2767153 | 1 | 1 | 39HQ 16.10 | 1479457 |
2767153 | 1 | 2 | 39HQ 16.10 | 1479458 |
2767153 | 1 | 3 | 39HQ 16.10 | 1479459 |
2767153 | 2 | 1 | 39QR 10.10 | 1479460 |
I want to group the PO row by the combination of OrderNo, Line och LineSuffix. So the table looks like to one below.
OrderNo | Line | LineSuffix | Name | PO |
2767153 | 1 | 1 | 39HQ 16.10 | 1479455, 1479457 |
2767153 | 1 | 2 | 39HQ 16.10 | 1479458 |
2767153 | 1 | 3 | 39HQ 16.10 | 1479459 |
2767153 | 2 | 1 | 39QR 10.10 | 1479460 |
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.