Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Grouping Question

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.

Community Browser