# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

## how to count all excepted duplicated values in a selection

Hi all,

I have a simple selection with 5 calls and ref. call (unique) :

NumberReference_Call
385444588 50b9d5daLyon1e0758d6
559900523 50ba0751Boul1e0d3da7
559900523 50ba0787Lyon2e031322
559900523 50bb41a9Lyon2e0147cc
695515128 50b9bf5fLyon2e0b191f

If I count total of Number = 5

If I count distinct of Number = 3

My question is how to count all (Number) excepted duplicated values (here 1 with 559900...) in a selection to get only 2 answers and not 3 ?

if you say (Total - Distinct)=2 works here but doesn't work with :

NumberReference_Call
55990052350b9d5daLyon1e0758d6
55990052350ba0751Boul1e0d3da7
55990052350ba0787Lyon2e031322
55990052350bb41a9Lyon2e0147cc
69551512850b9bf5fLyon2e0b191f

If I count total of Number = 5

If I count distinct of Number = 2

and 5-2 is wrong because the all excepted duplicated is 1

Thank's a lot for any idea !

Sebastien

Tags (4)
1 Solution

Accepted Solutions

## Re: how to count all excepted duplicated values in a selection

Try count({<Number={"=count(Number)=1"}>} Number)

talk is cheap, supply exceeds demand
2 Replies

## Re: how to count all excepted duplicated values in a selection

Try count({<Number={"=count(Number)=1"}>} Number)

talk is cheap, supply exceeds demand
Not applicable

## Re: how to count all excepted duplicated values in a selection

Thank's Gysbert,

you are right, it work's !