topic Re: Help with unique records in QlikView

Help with unique records

qlikuser222 — Sat, 16 Nov 2024 18:01:54 GMT

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

Re: Help with unique records

edwin — Wed, 30 Sep 2020 18:54:04 GMT

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.

Re: Help with unique records

Vegar — Wed, 30 Sep 2020 20:05:33 GMT

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

Re: Help with unique records

edwin — Wed, 30 Sep 2020 20:52:15 GMT

Thanks Vegar, i learned something today