Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

SjoerdvdLaar
New Contributor

Show all the values in a column of a dimention in one cell

I've got the following two names:

Names: Jack and Paul

Jack has performed the following actions:

Action, date

01, 12-12-2018

02, 13-12-2018

10, 30-12-2018

13, 28-12-2018

Paul has performed the following actions: 

Action, date

01, 15-12-2018

02, 17-12-2018

04, 19-12-2018

05, 21-12-2018

10, 25-12-2018

 

Now I want the following result:

Jack: 01, 02, 13, 10

Paul:  01, 02, 04, 05, 10

 

How can I do this?

 

1 Solution

Accepted Solutions
zhadrakas
Valued Contributor

Re: Show all the values in a column of a dimention in one cell

try the following Expression with Dimension Names
concat(distinct Action, ',')

regards
tim
3 Replies
zhadrakas
Valued Contributor

Re: Show all the values in a column of a dimention in one cell

try the following Expression with Dimension Names
concat(distinct Action, ',')

regards
tim
Highlighted
shiveshsingh
Honored Contributor

Re: Show all the values in a column of a dimention in one cell

Your Script:

 

T:LOAD *,'Jack' as Key INLINE [

Action, date

01, 12-12-2018

02, 13-12-2018

10, 30-12-2018

13, 28-12-2018
];
T:LOAD *,'Paul' as Key INLINE [
Action,date
01, 15-12-2018

02, 17-12-2018

04, 19-12-2018

05, 21-12-2018

10, 25-12-2018];

 

 

Text box expression :

='Paul:' & Concat({<Key = {'Paul'}>}Action,',')

 

='Jack:' & Concat({<Key = {'Jack'}>}Action,',')

 

 

SjoerdvdLaar
New Contributor

Re: Show all the values in a column of a dimention in one cell

Perfect, thanks!!