Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
cbaqirdhds
Contributor II

Dupes

This should be easy so I don't know why my brain can't get there.

I have a list of providers by facility. I need a table/pivot chart that shows those that are duplicated (based on NPI number) at the same facility. I can get =count( NPI) to show counts but I only want the provider info listed if the count > 1.

I would think the conditional expression =count(NPI)=>2 would work but I still see providers with only one occurrence at a facility.

For example, I only want those with >2 in this chart and the total to reflect that.

5-12-2017 1-22-31 PM.jpg

Tags (1)
1 Solution

Accepted Solutions
mwoolf
Honored Contributor II

Re: Dupes

Try:

=if(count( NPI)>=2,count(NPI))

for your expresssion

8 Replies
mwoolf
Honored Contributor II

Re: Dupes

Try:

=if(count( NPI)>=2,count(NPI))

for your expresssion

cbaqirdhds
Contributor II

Re: Dupes

Thank you!

sergio0592
Valued Contributor II

Re: Dupes

Or  you can try :

=count({<Provider={"=count(NPI)>=2"}>} NPI)
cbaqirdhds
Contributor II

Re: Dupes

When I try to create a bar chart, the totals don't appear right. Thoughts?

sergio0592
Valued Contributor II

Re: Dupes

Can you post a snapshot?

cbaqirdhds
Contributor II

Re: Dupes

So what I want is how many distinct cases of duplicated NPIs are there at each facility?

5-12-2017 1-57-04 PM.jpg !

sergio0592
Valued Contributor II

Re: Dupes

Can't open your .qvw because i'am on Personnal edition, but 262 is Count(distinct NPI) and 952 is Count(NPI)? That 's it?

cbaqirdhds
Contributor II

Re: Dupes

No. 262 is row count of the same expression. 952 is Sum of Rows.

Community Browser