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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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