Qlik sense how to count by dimension

[GraceGao]

Hi Experts,

How to calculate max price frequency by month as below? I have count record no. when the price is equal to max price, but it is just working on total result, not by the month.  in the pivot table , the month column is zero when the price is not the total max price. Please help. Thanks.

eg. count({<price = max(price)>} distinct record)

Product	Jan	Feb
Max price	Max price frequency	Max price	Max price frequency
Product A	$10.50	2	$11.70	1
Product B	$13.00	1	$9.90	1

[JustinDallas]

Not sure what's happening in that table, but you probably need to use AGGR.

AGGR 

I would start with something like

AGGR(count({<price = max(price)>} distinct record), product)

If I had some dummy data I could help.

[GraceGao]

Thanks for your reply.

I use below expression, but the result is not present the corresponding max price frequency, display the whole data set max price frequency.  is there any suggestion? i would like to display the frequency of this product max price.

aggr(count({<[price]={$(= max([price))}>}distinct record),product)

Report layout:  product, max price, max price frequency