# Qlik Sense App Development

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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?

Regards.

1 Solution

Accepted Solutions
MVP

## 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
MVP

## 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?

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

## 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
MVP

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

Contributor II

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

I know.. I was being sarcastic.

Here goes the sample.

Thank you.

Regards.

MVP

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

Contributor II

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

Thank you, again!

MVP

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

No problem again

Community Browser