show all text values of one dimension in one cell

[evgeniystuchalk]

Hello! I have a table like this:

Day	Deal ID
1	1
1	2
1	3
2	4
2	5

I need to conver it this, in a table widget:

Day	Deal ID
1	1&2&3
2	4&5

Its important to make it via calculated dimension or measure. Not vial loading script.

[tresesco · Accepted solution]

Chart:

Dimension : Day

Expression : Concat([Deal ID], '&')

[Anonymous]

hI

Try this

aggr(Concat([Deal ID]),Day)  in expression of PIVOT TABLE

[ecolomer]

Is this you need

[jayaseelan]

Hi,

Please find the following QVF file. Its your output.

Thanks,

[evgeniystuchalk]

Thaks, it works)

[evgeniystuchalk]

Thaks, it also works)

[evgeniystuchalk]

Thaks, but i'm using qlik sense.

[evgeniystuchalk]

Thak you too)