topic Avoid duplicates in QlikView

Avoid duplicates

Fri, 02 Nov 2012 15:09:37 GMT

I have two fields id and Product for example

id product

1 a

2 b

3 a

3 b

4 a

4 b

I should get

1 a

2 b

3 a

4 a

id should be uniqe and product should be lowest

Please help me

CELAMBARASAN — Fri, 02 Nov 2012 15:15:21 GMT

You can do it by using FirstValue and Group By clause

Sample:

Load * inline [

id ,product

1 ,a

2 ,b

3 ,a

3 ,b

4 ,a

4 , b];

DistinctProductList:

Load id, FirstValue(product) As DistinctProduct

Resident

Sample

Group By id;

Drop Table Sample;

Hope this helps

MayilVahanan — Fri, 02 Nov 2012 15:18:00 GMT

Please find attachment.