how do I do count if like in excel but not for particular value but for the field

[coloful_architect]

let 's say I have a table ,

key, product sku

just for that table, I want to know for each key how many product sku it has 

usually, at excel, we could do countif ( range of key, key),  do we have something similar at qlik sense?

[ogster1974]

not sure why you need a count if your ask sounds like a simple key, count([product sku]) as "No. product sku"

Perhaps some sample data will help illustrate your requirement clearer.

[coloful_architect]

yeah.. should be more precise,  if I use count product sku, it returns a number of counts cover all the rows at entire data set. but I only want to see the count for that particular table... see below, the first to third row share the same key,  but given by its three different product sku, It appears three rows. I want to have a qlik formula to catch that number. ( column three at the table)

Key	Product SKU	Qlik count : count([Product SKU])	excel Count
00014300373402236500480	A	3257	3
00014300373402236500480	B	187	3
00014300373402236500480	C	45	3
00014300373402236500640	D	1242	2
00014300373402236500640	E	95	2
00025003667402821701000	F	3667	3
00025003667402821701000	G	128	3
00025003667402821701000	H	125	3