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

[patriciousa]

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?

Thank you in advance.

Regards.

[sunny_talwar]

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

[#3]

What are the difference between QlikView and Qlik Sense?

[patriciousa]

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

[Gysbert_Wassenaar]

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.

[sunny_talwar]

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

[patriciousa]

I know.. I was being sarcastic.

Here goes the sample.

Thank you.

Regards.

[sunny_talwar · Accepted solution]

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

[patriciousa]

Thank you, again!

[sunny_talwar]

No problem again