Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be this
Count(DISTINCT {<name = {"=Count(name) > 1"}>} name)
Thanks! It suits perfectly:)