Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))))
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
What are the difference between QlikView and Qlik Sense?
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
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.
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
I know.. I was being sarcastic.
Here goes the sample.
Thank you.
Regards.
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))))
Thank you, again!
No problem again