How to Calculate Duplicate %

[Anonymous]

Gud Morning ,

Today I was going to calculate Duplicate % region wise,

but I stucked . Cany one please help me to come out from this problem.

Situation : Total Record = 267052

                Duplicate Record = 20322

Now want to know how much duplicate %  I have in each region.

Region	Total	Total Number of Duplicate Record	Duplicate region wise	Duplicate %
Americas	61048	20322	3807	18.73%
APAC	23957	20322	1195	5.88%
Emerging Markets	46519	20322	3346	16.46%
Europe	89447	20322	7037	34.63%
France	46080	20322	4937	24.29%

Can any one pls try ?

Now I want 20322 similary in text box.

or Straight table in qlick view similar like above table.

[Anil_Babu_Samineni]

I think you need TOTAL Keyword within the Count aggregation, Can you share the qvw file

[Anonymous]

Hi, Anil Babu

Please use the file attched in qlick view.

[Anil_Babu_Samineni]

The reason i ask you is, Your excel file corrupted. Can you load the excel and share the qvw?

[#5]

Hi

Use straight table with dimension Region.

For Total expression is =count(GID)

For Total number of duplicate records =Count(TOTAL GID)-Count(TOTAL DISTINCT GID)

for duplicate region wise =Count(GID)-Count(DISTINCT GID)

for % =(Count(GID)-Count(DISTINCT GID))/(Count(TOTAL GID)-Count(TOTAL DISTINCT GID))

Hope this helps

Regards

Krishna KS

[prma7799]

PFA...

[md_qlikview]

Hi,

PFA File for your reference.

[Anonymous]

Please share the expression.

As I don't have licence version.

Thanks,

[prma7799 · Accepted solution]

1.Count(GID)

2.((count(TOTAL {<Region>} GID)-count( DISTINCT  TOTAL {<Region >}  GID)))

3.Count(GID)-Count(DISTINCT  GID)

4.Column(3)/Column(2)

[prma7799]

Hi Bijay,

for Duplicate %