topic Re: Table - Sort a Measure by expression? or colours... in App Development

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

patriciousa — Thu, 14 Apr 2016 15:45:20 GMT

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.

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

sunny_talwar — Thu, 14 Apr 2016 15:46:56 GMT

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

Fri, 15 Apr 2016 12:20:16 GMT

What are the difference between QlikView and Qlik Sense?

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

patriciousa — Fri, 15 Apr 2016 14:44:17 GMT

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

Gysbert_Wassenaar — Fri, 15 Apr 2016 14:51:39 GMT

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

sunny_talwar — Fri, 15 Apr 2016 15:00:35 GMT

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

patriciousa — Fri, 15 Apr 2016 15:03:18 GMT

I know.. I was being sarcastic.

Here goes the sample.

Thank you.

Regards.

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

sunny_talwar — Fri, 15 Apr 2016 15:12:33 GMT

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

patriciousa — Fri, 15 Apr 2016 15:19:37 GMT

Thank you, again!

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

sunny_talwar — Fri, 15 Apr 2016 15:21:15 GMT

No problem again