topic Re: Counting values in QlikView

Counting values

Tue, 10 Jun 2014 11:43:31 GMT

Hi I have a table as presented below

Location
USA
USA
USA
Spain
Italy
Italy

I need to count what is the maximum repetition of a country. For ex. in this case the result of expression should be 3 (USA occur 3 times, I don't need to know what country it is, just amount). This is just a sample table so in real case I can't use set analysis because of huge amount of different countries

Any idea how to solve that ?

Re: Counting values

anbu1984 — Tue, 10 Jun 2014 11:47:39 GMT

=Max(Aggr(Count(Country),Country))

Re: Counting values

Anonymous — Tue, 10 Jun 2014 11:48:28 GMT

Go to straight Table->Don't add any dimension->Create the expression->Count(Country)->Sort(Descending)->Go to Dimension Limits->Restrict the number of vaues you want to display

Re: Counting values

ashfaq_haseeb — Tue, 10 Jun 2014 11:49:16 GMT

Hi.

do you mean like the attached?

Regards

ASHFAQ

Re: Counting values

MK_QSL — Tue, 10 Jun 2014 11:49:46 GMT

Try below in Text Box

For Number

=MAX(Aggr(COUNT(Location),Location))

For Location

=FirstSortedValue(Location, -Aggr(COUNT(Location),Location))