Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

May be this

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

View solution in original post

2 Replies

May be this

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

View solution in original post

Contributor II
Contributor II

Thanks! It suits perfectly:)