Discussion Board for collaboration on QlikView Layout & Visualizations.
I'm trying to combine multiple record that are related into same line.
this is how my reports looks
this is how I want it to look.
please let me know how this can be achieve.
thank you so much in advance!
Go to Solution.
Then try it like this
Aggr(Concat(DISTINCT ID, '-'), Description)
View solution in original post
In the script or in the chart?
Perhaps like this:
concat(ID, '-') as ID,
sum(Total) as Total
how would that work if the ID comes from a different Source Table and linked by description?
I was trying it in the chart originally.
Thank you for all your help!