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: 
Jérôme5625
Creator
Creator

Grouping of datas on a "data

Hello, need a little help on my very specific request.
I am recovering quality data namely a line of data by default and by vehicle number. I am attaching the file.
My objective is to use a filter field to select the identification number and I would like the defects of this number to be written in list.
I explain myself:
If we choose the number for example 129872, I would like that in my table element that there are not several lines for each defect but rather a single line that groups the defects with a separation by a comma:

- Parts missing , Parts Broken

Thanks in advance and have a nice day

Labels (2)
1 Reply
Dalton_Ruer
Support
Support

You simply need to use the CONCAT function which will concatenate other fields at the dimensional value level. 

Concat([Type de défaut], ', ')

Here is example

ConcatFunction.png