topic Load Distinct Values in QlikView

Load Distinct Values

chinnuchinni — Wed, 25 Nov 2020 16:16:04 GMT

Hi Every one,

I have 3 fields in a table A,B,C.

i need to load distinct of A values and also i need 3 fields.

if i keep

load distinct A, B, C from xyz;

it is giving only the distinct rows.

please help me on this.

Regards

Praveen

Re: Laod Distinct values

shraddha_g — Wed, 29 Nov 2017 06:57:07 GMT

Can you share sample data and expected output.

If you need Only Distinct A but with other 2 Fields. What will be the criteria to filter other 2 columns?

Because if load Distinct A and Left join B and C to A then again it will duplicate values from A.

Re: Laod Distinct values

chinnuchinni — Wed, 29 Nov 2017 07:12:43 GMT

Actually in A we have data 1,2,3,4,5,6.........some fields are repeated

In B we have data 1,2,3,.........which are repeated

In C we have date which are associate dates which are repeated.

now i want the out put : distinct A values ,min(C) dates,associate B values

Re: Laod Distinct values

shraddha_g — Wed, 29 Nov 2017 07:52:48 GMT

then you can try

Load A,B, Min(C) as C

From XYZ

Group by A,B;

Re: Laod Distinct values

chinnuchinni — Wed, 29 Nov 2017 08:50:04 GMT

i tried but with that am not getting distinct A values. some values are repeating

Re: Laod Distinct values

shraddha_g — Wed, 29 Nov 2017 08:56:55 GMT

you can try (not so sure about it)

Table1:

Load A &'-'& Min(C) as Key,

A,Min(C) as C

From XYZ

Group by A;

Left Join (Table1)

Load A &'-'& C as Key,

From XYZ;

Re: Laod Distinct values

antoniotiman — Wed, 29 Nov 2017 09:13:52 GMT

Try this

LOAD A,FirstSortedValue(DISTINCT B,C) as B,Min(C) as C

From ...

Group By A;

Re: Laod Distinct values

kiko1955 — Thu, 30 Nov 2017 23:15:22 GMT

Datos:
Load * inline [
A,B,C
1,2,3
1,3,4
2,4,5
2,4,5
3,1,2
4,3,1
4,5,6
5,2,3
];
NoConcatenate
SinRepetir:
Load
A as AA,
B as BB,
C as CC
Resident Datos
Where Previous(A) <> A
Order by A