Qlik Community

Ask a Question

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 
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