Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
GraceGao
Creator
Creator

Qlik sense how to count by dimension

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)

ProductJanFeb
Max priceMax price frequencyMax priceMax price frequency
Product A$10.502$11.701
Product B$13.001$9.901
2 Replies
JustinDallas
Specialist III
Specialist III

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
Creator
Creator
Author

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