counting values based on condition

[pgonin]

Hello guys!

I'm a bit new to QlikSense, so please don't judge me 🙂

Let's say I have a column with names 

LOAD * Inline [

name ,

a,

b,

c,

c,

a,

b,

d

];

The question is, how do I count the amount of names which appear in this column (let's say) twice?

Normally "a", "b" and "c" appear twice in the column, so the answer on my question should be 3.

Thanks in advance!

[sunny_talwar · Accepted solution]

May be this

Count(DISTINCT {<name = {"=Count(name) > 1"}>} name)

[pgonin]

Thanks! It suits perfectly:)