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.
|Region||Total||Total Number of Duplicate Record||Duplicate region wise||Duplicate %|
Can any one pls try ?
Now I want 20322 similary in text box.
or Straight table in qlick view similar like above table.
I think you need TOTAL Keyword within the Count aggregation, Can you share the qvw file
The reason i ask you is, Your excel file corrupted. Can you load the excel and share the qvw?
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