How to create a table with calculated dimension in Qlik Sense

[vishal-nhm]

Hey Guys,

I have below database which has UID and wanted to generate a table which will give me count of duplicate UID based on calculated dimension. 

Actually, I wanted to generate a table to see how many users are downloading our content multiple times. Something similar to output table. Please see below (second table). 

database:

UID	Content ID	Type
98	a19	A
99	c1	D
98	a38	A
98	a40	A
103	d12	E
110	a21	B
103	a11	C
110	b27	C
107	a19	A
109	a19	D
110	c20	C
98	d1	D

output:

Number of downloads	=count(UID)
1	3
2	1
3	1
4	1

Can you guys help me on this please?

Thanks

Vishal

[sunny_talwar]

Try this

Dimension

Aggr(Count([Content ID]), UID) 

Expression

Count(DISTINCT UID)