Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pgonin
Contributor II
Contributor II

counting values based on condition

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!

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

May be this

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

View solution in original post

2 Replies
sunny_talwar

May be this

Count(DISTINCT {<name = {"=Count(name) > 1"}>} name)
pgonin
Contributor II
Contributor II
Author

Thanks! It suits perfectly:)