Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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
Specialist III
Specialist III

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
Specialist III
Specialist III

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

Vegar
MVP
MVP

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
edwin
Specialist III
Specialist III

Thanks Vegar, i learned something today