Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
iralza01
Contributor II
Contributor II

Hi, I need to obtain the nº of vehicle with max cost.

Hi, I have different vehicles with different cost and I want to obtain the number of vehicle with max cost.

Thanks

6 Replies
sunny_talwar

Not sure I understand completely, but may be this:

Count({<Cost = {$(=Max(Cost))}>} Vechicle)

iralza01
Contributor II
Contributor II
Author

Thank you Sunny, but it returns the total nº of vehicles...

For one city (ex Barcelona) I have 25 vehicles (a, b, c, d....) and each vehicle has a cost. I want for Barcelona the letter of vehicle with max cost.

sunny_talwar

May be this

Dimension:

City

Expression:

FirstSortedValue(letter, -Cost)

iralza01
Contributor II
Contributor II
Author

Thank you, it works!

And now it would be possible to represent as a pot each vehicle in the following chart? now it only shows the vehicle with max cost and I would like to show the different vehicles to see cost distribution in the city:

sunny_talwar

Not sure I understand what you are looking for?

And now it would be possible to represent as a pot each vehicle in the following chart? now it only shows the vehicle with max cost and I would like to show the different vehicles to see cost distribution in the city

iralza01
Contributor II
Contributor II
Author

I would like to show in X axis the city id, in Y axis maximun cost of the vehicle and in the pots the diferent vehicles (a, b,c) for each city. to see the differences between cities and the cost of the vehicles.

Maybe it is not possible...