Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Partner
Partner

show all text values of one dimension in one cell

Hello! I have a table like this:

DayDeal ID
11
12
13
24
25

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

DayDeal ID
11&2&3
24&5

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: show all text values of one dimension in one cell

Chart:

Dimension : Day

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

View solution in original post

8 Replies
Highlighted
MVP
MVP

Re: show all text values of one dimension in one cell

Chart:

Dimension : Day

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

View solution in original post

Highlighted
galax_allu
Valued Contributor

Re: show all text values of one dimension in one cell

hI

Try this

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

Highlighted
ecolomer
Honored Contributor II

Re: show all text values of one dimension in one cell

Is this you need

P_232226.png

Highlighted
jayaseelan
Contributor III

Re: show all text values of one dimension in one cell

Hi,

Please find the following QVF file. Its your output.

Thanks,

Highlighted
Partner
Partner

Re: show all text values of one dimension in one cell

Thaks, it works)

Highlighted
Partner
Partner

Re: show all text values of one dimension in one cell

Thaks, it also works)

Highlighted
Partner
Partner

Re: show all text values of one dimension in one cell

Thaks, but i'm using qlik sense.

Highlighted
Partner
Partner

Re: show all text values of one dimension in one cell

Thak you too)