topic Can't sort str. table when use COLORMIX as cells background !?! in QlikView

Can't sort str. table when use COLORMIX as cells background !?!

ivan_will — Sun, 17 Apr 2011 11:22:14 GMT

Hi all,

When use colormix wizard (in straight table) with this expr:

ColorMix1 ((1+Sign(2*(rangemin(5.5,rangemax([Air Conditioning],0.5))-0.5)/(5.5-0.5)-1)*Sqrt(Fabs((2*(rangemin(5.5,rangemax([Air Conditioning],0.5))-0.5)/(5.5-0.5)-1))))/2, ARGB(255, 255, 255, 255), ARGB(255, 255, 205, 5))

it's unavailable to sort the table !!!??

When use simple colormix: ColorMix1([Air Conditioning]*0.02,White(),red())

it is possible !

Any ideas how to make the first one working ?

Can't sort str. table when use COLORMIX as cells background !?!

ivan_will — Sun, 17 Apr 2011 17:25:09 GMT

Can't sort str. table when use COLORMIX as cells background !?!

ivan_will — Mon, 18 Apr 2011 07:47:40 GMT

any ideas ? or it is : "Working as designed"?

Can't sort str. table when use COLORMIX as cells background !?!

ivan_will — Mon, 18 Apr 2011 14:45:28 GMT

QlikView: "This is a bug and will be fixed in the next releases! "

Re: Can't sort str. table when use COLORMIX as cells background !?!

dcd123456 — Thu, 28 Aug 2014 09:46:23 GMT

Hello Ivan

Which version of QV do you have?

i have QV 11.20 and i have the same problem

regards

Re: Can't sort str. table when use COLORMIX as cells background !?!

avinashelite — Thu, 28 Aug 2014 09:49:33 GMT

Hi,

try writing expression in the sorting.

Re: Can't sort str. table when use COLORMIX as cells background !?!

dcd123456 — Thu, 28 Aug 2014 09:54:39 GMT

No, it not works, i write the expresion in the sorting tab, but don't works.

regards