topic Re: count duplicated value in QVD in QlikView

count duplicated value in QVD

Sun, 26 Jan 2014 09:37:20 GMT

Hello Experts,

I want to generate output variable in my qvd file, please help.

Sun, 26 Jan 2014 09:49:37 GMT

Please try this as expression where ID and FID are dimensions in straight table:

=Left(aggr(Rank(FID),ID),1)

Thanks,

Angad

Sun, 26 Jan 2014 10:53:47 GMT

Hi,

A Group By on Load should do.

Assuming you just wanna test this from you qvd file, and no null in ID:

CountTable:

LOAD ID, FID, count(ID) as Output

FROM Table.qvd(qvd)

Group By ID, FID

;

If you wanna load other data from the qvd, better do the Group By after on Resident table, it should be faster:

Table:

Load *

FROM Table.qvd(qvd)

;

Left join(Table)

LOAD ID, FID, count(ID) as Output

Resident Table

Group By ID, FID

;

Hope this helps

whiteline — Sun, 26 Jan 2014 12:25:12 GMT

Left join(Table)

LOAD ID, FID, count(ID) as Output

Resident Table

Group By ID, FID

Otherwise you'll get 1 for each row.

Mon, 27 Jan 2014 03:23:22 GMT

Thanks mate, appreciated your help!

Mon, 27 Jan 2014 03:24:19 GMT

Thanks mate, appreciated your help!