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.

15 Replies
Kush
MVP
MVP

May be this

=Sum(aggr(Count(GID3) - Count(distinct  GID3), Region))

bijay_jha
Creator
Creator
Author

Aggr function will not work here, as it gives only one outcome as result

Kush
MVP
MVP

have you tried it? what is the output you are getting?

bijay_jha
Creator
Creator
Author

yes

anilkumarboddu
Contributor II
Contributor II

If your using list box, you have to check frequency check box in list box properties

bijay_jha
Creator
Creator
Author

True,

But it was given only to test the formula.