Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Help with unique records

Hi All,

Can anyone please help me to achieve below results using Qlik

ID,  Name,  Date,       Country,   Type,   record

1,  Peter,    2/1/2019, USA,         EDIT,     123

1,  Peter,    2/1/2019, USA,        COPY,     567

I want the above records to be displayed as below in QLIK Table

ID,  Name,  Date,       Country,   Type,          record

1,  Peter,    2/1/2019, USA,         EDIT;COPY, 123;567

 

Thanks

 

 

Labels (3)
1 Solution

Accepted Solutions
edwin
Master II
Master II

the nearest is a straight table:

add following dimensions: ID,  Name,  Date,  Country
add two expressions:
=concat(distinct type,';')
=concat(distinct record,';')

however, the problem with concat is it arranges the values in sort order so it will be 
COPY;EDIT    123;567

if a tweak is acceptable, use only one expression column:
=concat(distinct type & ';' & record, ',')
the advantage of this is that the type and corresponding record are paired up.

View solution in original post

3 Replies
edwin
Master II
Master II

the nearest is a straight table:

add following dimensions: ID,  Name,  Date,  Country
add two expressions:
=concat(distinct type,';')
=concat(distinct record,';')

however, the problem with concat is it arranges the values in sort order so it will be 
COPY;EDIT    123;567

if a tweak is acceptable, use only one expression column:
=concat(distinct type & ';' & record, ',')
the advantage of this is that the type and corresponding record are paired up.

Vegar
MVP
MVP

You could probably get the order correct if you use the same sort-weight parameter in both the concat function. 

edwin
Master II
Master II

Thanks Vegar, i learned something today