Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

0 Replies