# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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 %