Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
evgeniystuchalk
Not applicable

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
tresesco
Not applicable

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

Chart:

Dimension : Day

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

8 Replies
tresesco
Not applicable

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

Chart:

Dimension : Day

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

galax_allu
Not applicable

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

hI

Try this

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

ecolomer
Not applicable

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

Is this you need

P_232226.png

jayaseelan
Not applicable

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

Hi,

Please find the following QVF file. Its your output.

Thanks,

evgeniystuchalk
Not applicable

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

Thaks, it works)

evgeniystuchalk
Not applicable

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

Thaks, it also works)

evgeniystuchalk
Not applicable

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

Thaks, but i'm using qlik sense.

evgeniystuchalk
Not applicable

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

Thak you too)