Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
patriciousa
Contributor II

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?

Thank you in advance.

Regards.

1 Solution

Accepted Solutions

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



9 Replies

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

Not applicable

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

What are the difference between QlikView and Qlik Sense?

patriciousa
Contributor II

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

MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand

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

patriciousa
Contributor II

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



patriciousa
Contributor II

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

Thank you, again!

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

No problem again