# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

## Max value aggregate Qlik sense

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.

Tags (2)
6 Replies
Valued Contributor

## Re: Max value aggregate Qlik sense

Can you share some data?

New Contributor II

## Re: Max value aggregate Qlik sense

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???

Valued Contributor

## Re: Max value aggregate Qlik sense

Maybe this can help

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

New Contributor II

## Re: Max value aggregate Qlik sense

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?

Valued Contributor

## Re: Max value aggregate Qlik sense

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

Contributor II

## Re: Max value aggregate Qlik sense

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.