Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Count and NODISTINCT

I don't understand which kind of formula I must use and how to write it...I must count the number of suppliers and even if they are repeated, they must be counted! in the file I use

count([Ragione Sociale Fornitore])

but this formula gives me 15 instead of 18 (since 3 suppliers are repeated). How can I get 18???

Please find the file attached

Tags (2)
1 Solution

Accepted Solutions

Re: Count and NODISTINCT

Sono riuscito a scaricare il documento:

ecco l'espressione che ti serve ...

Sum(Aggr(count( [Ragione Sociale Fornitore]), [Numero Documento]))

fammi sapere

2 Replies

Re: Count and NODISTINCT

Sono riuscito a scaricare il documento:

ecco l'espressione che ti serve ...

Sum(Aggr(count( [Ragione Sociale Fornitore]), [Numero Documento]))

fammi sapere

Not applicable

Re: Count and NODISTINCT

Grazie mille Alessandro Saccone!!!!!! non riuscivo proprio a capire dove sbagliassi...grazie!!

Community Browser