Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 % |
---|---|---|---|---|
Americas | 61048 | 20322 | 3807 | 18.73% |
APAC | 23957 | 20322 | 1195 | 5.88% |
Emerging Markets | 46519 | 20322 | 3346 | 16.46% |
Europe | 89447 | 20322 | 7037 | 34.63% |
France | 46080 | 20322 | 4937 | 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.
May be this
=Sum(aggr(Count(GID3) - Count(distinct GID3), Region))
Aggr function will not work here, as it gives only one outcome as result
have you tried it? what is the output you are getting?
yes
If your using list box, you have to check frequency check box in list box properties
True,
But it was given only to test the formula.