9 Replies Latest reply: Apr 15, 2016 8:20 AM by Anil Babu

# Table - Sort a Measure by expression? or colours...

Hi Community.

I have a column in my table (Measure) that I need to sort by colours.... Red, Orange, Yellow, Green.

The column is a sum of totals.

Is it possible to sort the order of a measure?

Regards.

• ###### Re: Table - Sort a Measure by expression? or colours...

You sure can, but you would need to give these colors some sort of values so that they can be sorted numerically rather than by text. I would look into Dual function to do this.

UPDATE: As this is Qlik Sense, I am not aware if there are any specific limitations, but in QlikView this should be straight forward

• ###### Re: Table - Sort a Measure by expression? or colours...

What are the difference between QlikView and Qlik Sense?

• ###### Re: Table - Sort a Measure by expression? or colours...

If the great Sunny can't do this, it is impossible.

Qlik Sense needs and update to have all the things that Qlik View have

• ###### Re: Table - Sort a Measure by expression? or colours...

I think you're jumping to conclusions. Sunny did not say it's impossible. Please post a small Qlik Sense app that illustrates the problem.

• ###### Re: Table - Sort a Measure by expression? or colours...

Yup, in fact I did say that it might well be possible, I just don't know how well can it be done in Qlik Sense. It would be best if you can share a sample as mentioned by Gysbert

• ###### Re: Table - Sort a Measure by expression? or colours...

I know.. I was being sarcastic.

Here goes the sample.

Thank you.

Regards.

• ###### Re: Table - Sort a Measure by expression? or colours...

Use this sorting expression:

If(Max(Aggr(Sum({<"NombreHoraExtra"={"Hora Extra 100"}>} Cantidad), [Fecha Registro], Nombre)) >12, 4,

If(Max(Aggr(Sum({<"NombreHoraExtra"={"Hora Extra 100"}>} Cantidad), [Fecha Registro], Nombre)) >8, 3,

If(Max(Aggr(Sum({<"NombreHoraExtra"={"Hora Extra 100"}>} Cantidad), [Fecha Registro], Nombre)) >4, 2,

If(Max(Aggr(Sum({<"NombreHoraExtra"={"Hora Extra 100"}>} Cantidad), [Fecha Registro], Nombre)) <=4, 1))))

• ###### Re: Table - Sort a Measure by expression? or colours...

Thank you, again!

• ###### Re: Table - Sort a Measure by expression? or colours...

No problem again