Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sarah910
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.

6 Replies
zebhashmi
Valued Contributor

Re: Max value aggregate Qlik sense

Can you share some data?

sarah910
New Contributor II

Re: Max value aggregate Qlik sense

    Here I have attached the data.

Property_idNumber_of_ReviewsPrice
116757155185
116757152165
914702530125
55573817569
662744912125
18868200300
160424780200
116757152199
91157000139
152205385110
7730416239
2605662040
71527010339
148729531752
34297656145
34351961140

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
Valued Contributor

Re: Max value aggregate Qlik sense

Maybe this can help

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

Capture.PNG

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

zebhashmi
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

justinphamvn
Contributor II

Re: Max value aggregate Qlik sense

Hi Sara,

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

maxPrice.png

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

Hope this helps,

Justin.

Community Browser