Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Count Distinct ID where ID Occurs more than once

Hi All,

I am trying to create a chart from my data set where I am getting a count of distinct id's where the id occurs more than once.

Below is a look at a pivot chart i created using the data. Any idea?

qlik.JPG

15 Replies
Highlighted

May be this

Count({<ID = {"=Count(ID) > 1"}>}ID)

Highlighted
Contributor III
Contributor III

Hi stalwar1,

I have tried that formula but it doesnt seem to work for some reason.

Finbar

Highlighted

It may be confidential, but are you using set analysis between Count and ID which you have colored in Red? Are you using the same set analysis in the Search string?

Highlighted
Contributor III
Contributor III

I am doing a simple count(id) in the table above. So it is telling me how many times the unique policy id occurs in the table.

Highlighted

I was asking about this

Capture.PNG

Is the hidden part in Red a set analysis? or what?

Highlighted
Contributor III
Contributor III

No it is a simple count... i just hid part of the column name.

Highlighted

oh okay... can you post a screenshot with this new expression

Count({<ID = {"=Count(ID) > 1"}>}ID)

Highlighted
Contributor III
Contributor III

qlik.JPG

The second column is where your expression has been added

Highlighted

Oh so it is working... all you need to do is.... remove the first expression and under Add-ons -> Data handling uncheck 'Include Zero Values'