topic Counting duplicate facts in QlikView

Counting duplicate facts

Thu, 21 Nov 2013 06:47:21 GMT

Lets take an example of a table having three columns: City ID(Unique), People, Frequency(to be calculated)

I want the Frequency column to be populated with count as shown above. How can I acheive this?

kaushiknsolanki — Thu, 21 Nov 2013 06:51:37 GMT

Hi,

Try this.

Data:

Load CITY_ID,People From xyz;

Left join(Data)

Load People,Count(People) as Freq resident Data group by People;

Regards,

Kaushik Solanki

er_mohit — Thu, 21 Nov 2013 08:00:17 GMT

Try this

aggr(NODISTINCT Count(People),People)