Discussion board where members can get started with Qlik Sense.
I need to merge some cells from differents rows from a table, is it possible?
My data looks something like the below :
and i want as a result
I was thinking about using the "concat" function, but it seems it wrong the dimension...
is there any way to do this with many lines?
Go to Solution.
In the Dimension, you can try this
Aggr(Concat(DISTINCT Code, ', '), Name)
Concat is the right way to go...
Concat (Code, ', ') as Code,
Group By Name, Firstname, Valid;
This one actually worked the way I wanted to ! Thanks