Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Contributor II

Aggr Count

The goal is to show a count of Providers with Duplicate entries (same NPI, name, specialty) at a facility.

In the example below, in the detailed chart, I use =if(count( NPI)>=2,count(NPI)) and get 262 as the numeric count of rows (as opposed to the sum of the rows). This means there are 262 providers at this facility that are duplicated.

I want a bar chart to show the total number of duplicate providers at each facility but this number is not the same. I believe I need to use an AGGR statement but I can't figure out how. The bar chat's only dimension would be facility but I still want to show the same logic.

This is not giving me what I need: =sum(aggr(count( NPI)>=2,FACILITY))

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Aggr Count

May be this?

=Sum(Aggr(If(Count(NPI) >= 2, 1), FACILITY, NPI, FULL_NAME))

4 Replies
MVP
MVP

Re: Aggr Count

May be this?

=Sum(Aggr(If(Count(NPI) >= 2, 1), FACILITY, NPI, FULL_NAME))

cbaqirdhds
Contributor II

Re: Aggr Count

Long time no chat, Sunny! Thanks

cbaqirdhds
Contributor II

Re: Aggr Count

One more question... I need a count if NPI is null by Facility.

MVP
MVP

Re: Aggr Count

May be

NullCount(NPI)