count number of occurences

[krivozhnya]

Hi, hope someone can point in the right direction.

I've a chart/table like so:

accountID email

123     a@gmail.com

234 a@gmail.com

345 b@gmail.com

I need to display # of times each email is repeated, i.e.

accountID email #repeates

123 a@gmail.com 2

234  a@gmail.com 2

345 b@gmail.com 1

in Excel I'd use something like countif (B:B,b2) and drag across rows 2/3/4.

In qlik, I've tried count with aggr but can't get it to work.

Thank you,

[Kushal_Chawda · Accepted solution]

@krivozhnya  with dimension Account & Email you can use below expression

=count(total <email>email)

[krivozhnya]

Perfect, you're a wizard, sir!