Get the value of 1 Dimension on the same colomn

[Pierremeesters]

Hi, 

i've got this data:

Everything is the same except the 'dagen'.  how do i get it that its just one line but with the 'dagen' like this:

Dinsdag, Woensdag,Donderdag,Vrijdag,Zaterdag. in one line? 

[hic · Accepted solution]

You have too many dimensions. Especially, you cannot have "Dagen" as dimension. Use 

Concat("Dagen", ', ') 

as measure instead.

Several of your dimensions should be measures instead. Take a look at

https://community.qlik.com/t5/Design/Dimensions-and-Measures/ba-p/1473017