# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Did you mean:
Creator

## How to Calculate Duplicate %

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.

RegionTotalTotal Number of Duplicate RecordDuplicate region wiseDuplicate %
Americas6104820322380718.73%
APAC239572032211955.88%
Emerging Markets4651920322334616.46%
Europe8944720322703734.63%
France46080203224937

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.

1 Solution

Accepted Solutions
Master III

1.Count(GID)

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

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

4.Column(3)/Column(2)

15 Replies

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

Hi, Anil Babu

Please use the file attched in qlick view.

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable

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

Master III

PFA...

Creator II

Hi,

PFA File for your reference.

Creator
Author

Please share the expression.

As I don't have licence version.

Thanks,

Master III

1.Count(GID)

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

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

4.Column(3)/Column(2)

Master III

Hi Bijay,

for Duplicate %