Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
irmantas
New Contributor III

Is it posable?

Hi All,

I have this:

 

MonthDayCity
1122    Kaunas
1123   Vilnius
1124   Kaunas
1124Klaipeda
1125Kaunas

Need this:

  

Mont
Day11
22Kaunas
23Vilnius
24Kaunas, Klaipeda
25Kaunas

Is it posable to show few results in one cell? I want show it in PivotTable.

Tags (1)
1 Solution

Accepted Solutions
devarasu07
Honored Contributor II

Re: Is it posable?

Yes, just use concatenate with pivot table

Concat(City,',')

or

=aggr(Concat(City,','),Day) // if u r adding dimension as Calculated dimension

Capture.JPG

View solution in original post

2 Replies
devarasu07
Honored Contributor II

Re: Is it posable?

Yes, just use concatenate with pivot table

Concat(City,',')

or

=aggr(Concat(City,','),Day) // if u r adding dimension as Calculated dimension

Capture.JPG

View solution in original post

irmantas
New Contributor III

Re: Is it posable?

Thank you. It's working.