Max value aggregate Qlik sense

[Anonymous]

hi, I am new to Qlik sense.

I am trying to create an expression. I have property id's, price and their number of reviews. So i have to calculate which highly priced property has how many reviews?

I made a bar chart and set price [created a master item i.e. Max(Price)] and property id and set them both as 2 dimensions and Reviews as measure i.e. Count(Reviews). But I am not getting the correct graph for that.

Please tell me what should be the expression for it and how do I set my dimensions and measures.

[zebhashmi]

Can you share some data?

[Anonymous]

    Here I have attached the data.

Property_id	Number_of_Reviews	Price
11675715	51	85
11675715	21	65
9147025	30	125
5557381	75	69
6627449	12	125
1886820	0	300
16042478	0	200
11675715	21	99
9115700	0	139
15220538	5	110
773041	62	39
260566	20	40
715270	103	39
14872953	17	52
3429765	61	45
3435196	11	40

I have find the highly priced listings and their number of reviews. Also I have same property ids who have different prices. so also have to find the highest price of them and then map it. can you please tell me that shall I set price as a dimension along with property id and number of reviews as measure???

[zebhashmi]

Maybe this can help

only({<Price ={'>100'}>}Number_of_Reviews)

[Anonymous]

So do I set the price and property id both as dimensions and reviews as measure in this case? and Also Is there any need to use the Max function?

[zebhashmi]

In Bar chart i think you can have only one Dim.

so i am not being able to see what exactlly you are look for. you can try use rank in there as well

Regards

[justinphamvn]

Hi Sara,

Did you mean sum(Review) of highest price and aggr these by Property_ID ?

Try this Measure: FirstSortedValue(aggr(sum({<Price=>}Number_of_Reviews),Property_id,Price),-Price)

Hope this helps,

Justin.