topic Re: Sort Feature Not Working in Qlik Learning Discussions

Sort Feature Not Working

ryanfoster84 — Thu, 04 Dec 2014 16:54:53 GMT

Hi,

Can anyone help with an issue i am having. I have applied a background color to an expression in the definition field but when i try and sort the field nothing happens.

any suggestions?

thanks,

Ryan

Re: Sort Feature Not Working

whiteline — Thu, 04 Dec 2014 21:00:33 GMT

Hi.

Could you provide some more info? The chart type. The expression that you've used.

The sample application would be the best choice.

Re: Sort Feature Not Working

ryanfoster84 — Fri, 05 Dec 2014 09:54:37 GMT

Hi,

Its a straight Table and the definition is as follows:

ColorMix2 (if(sum(ADV)/count([Trade Date])<5000,-Sqrt(-(sum(ADV)/count([Trade Date])-100)/(100-RangeMin (top(total sum(ADV)/count([Trade Date])

,1,NoOfRows(total))))),Sqrt((sum(ADV)/count([Trade Date])-100)/(RangeMax (top(total sum(ADV)/count([Trade Date]),1,NoOfRows(total)))-100)))

, ARGB(255, 255, 0, 0), ARGB(255, 0, 64, 128), ARGB(255, 255, 255, 255))

the table looks like this

I can't share the application as it contains sensitive information sorry.

Re: Sort Feature Not Working

whiteline — Fri, 05 Dec 2014 14:49:31 GMT

Hi.

If you comment the color expression and everything works fine, then step by step try to avoid using inter-record functions and NoOfRows function.

Re: Sort Feature Not Working

Anonymous — Fri, 05 Dec 2014 20:30:27 GMT

It appears that the sort functions are put out of play when using ColorMix. I just tested it and get the same results. Not sure if this is a bug or not. I will look into it. You can still sort using the Dimension but apart from that it seems that no other sorting works.

Re: Sort Feature Not Working

ryanfoster84 — Mon, 08 Dec 2014 08:34:36 GMT

Hi Morris,

thanks for looking into it, it defiantly looks like a bug to me very frustrating!

thanks,

Ryan

Re: Sort Feature Not Working

hic — Mon, 08 Dec 2014 10:59:05 GMT

No, it's not a bug.

If you use inter-record functions, e.g. Top(), Above(), etc., you need to sort by expression.

HIC

Re: Sort Feature Not Working

ryanfoster84 — Mon, 08 Dec 2014 11:29:42 GMT

so would you use the background color definition in the sort by expression? Eg

ColorMix2 (if(sum(ADV)/count([Trade Date])<5000,-Sqrt(-(sum(ADV)/count([Trade Date])-100)/(100-RangeMin (top(total sum(ADV)/count([Trade Date])

,1,NoOfRows(total))))),Sqrt((sum(ADV)/count([Trade Date])-100)/(RangeMax (top(total sum(ADV)/count([Trade Date]),1,NoOfRows(total)))-100)))

, ARGB(255, 255, 0, 0), ARGB(255, 0, 64, 128), ARGB(255, 255, 255, 255))

Re: Sort Feature Not Working

Anonymous — Mon, 08 Dec 2014 12:00:59 GMT

In this case I would use the expression used to calculate ADV or Passive Ratio as the Sort by expression. Again you can only do this on the dimension and not the expression.

Re: Sort Feature Not Working

ryanfoster84 — Mon, 08 Dec 2014 13:01:20 GMT

thanks for the reply works great, hopefully they fix this issue

Re: Sort Feature Not Working

oknotsen — Mon, 08 Dec 2014 14:53:27 GMT

If it is not a bug, they probably will not "fix" it.

See reply by HIC.

Re: Sort Feature Not Working

Anonymous — Tue, 09 Dec 2014 07:51:48 GMT

I thought for some reason that it wouldn't affect the actual expression sorting as it was a background color expression but I understand that it is still calculating the color using the Top() function so not beeing able to sort this way makes sense. Thanks.