topic Re: Removing duplicates in QlikView

Removing duplicates

suraj_qlik — Fri, 15 Nov 2024 23:23:12 GMT

Hello Guys,

Can you help to remove the duplicates from a chart which would look something like this:(sample data)

KPI_1	KPI_2	Correlation
A	B	.5
B	A	.5
A	D	.6
C	D	.5
D	A	0.6

It should look like the following:

KPI_1	KPI_2	Correlation
A	B	.5
A	D	.6
C	D	.5

so since correlation of A and B is same as B & A, hence I want those to removed.

Please help.

Re: Removing duplicates

Anil_Babu_Samineni — Mon, 04 Jan 2021 09:16:36 GMT

Does it mean, If KPI1 or KPI2 having similar values it should not point to duplicate value or Correlation?

Re: Removing duplicates

suraj_qlik — Mon, 04 Jan 2021 09:37:29 GMT

Yes, correct @Anil_Babu_Samineni . We should be able to see just correlation of A & B and not B & A (as it will be same)

Re: Removing duplicates

Frank_Hartmann — Mon, 04 Jan 2021 11:45:40 GMT

tmp: LOAD In, RecId, Concat(Char) as Out,KPI_1, KPI_2, Correlation GROUP BY In, RecId,KPI_1, KPI_2, Correlation; LOAD *, Recno() as RecId, Mid(In,Iterno(),1) as Char WHILE iterno() <= Len(In); Load *, KPI_1&KPI_2&Correlation as In; Load * Inline [ KPI_1, KPI_2, Correlation A, B, 0.5 B, A, 0.5 A, D, 0.6 C, D, 0.5 D, A, 0.6 ]; NoConcatenate final: load *, if(Out=peek(Out,-1),Null(),Out) as test Resident tmp Where if(Out=peek(Out,-1),Null(),Out)<>Null() Order by Out; DROP Table tmp;