Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
iralza01
Not applicable

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 applicable

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

Not sure I understand completely, but may be this:

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

iralza01
Not applicable

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

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
Not applicable

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

May be this

Dimension:

City

Expression:

FirstSortedValue(letter, -Cost)

iralza01
Not applicable

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

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 applicable

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

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
Not applicable

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

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