Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
bijay_jha
Creator
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 ?

Acutal Duplicate.jpg

Now I want 20322 similary in text box.

or Straight table in qlick view similar like above table.

1 Solution

Accepted Solutions
prma7799
Master III
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)

View solution in original post

15 Replies
Anil_Babu_Samineni

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)
bijay_jha
Creator
Creator
Author

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?

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

prma7799
Master III
Master III

PFA...

md_qlikview
Creator II
Creator II

Hi,

PFA File for your reference.

bijay_jha
Creator
Creator
Author

Please share the expression.

As I don't have licence version.

Thanks,

prma7799
Master III
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)

View solution in original post

prma7799
Master III
Master III

Hi Bijay,

Bji.png

for Duplicate %

bhhh.png