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

[ivan_will]

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 ?

[ivan_will]

?

[ivan_will]

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

[ivan_will]

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

[dcd123456]

Hello Ivan

Which version of QV do you have?

i have  QV 11.20 and i have the same problem

regards

[avinashelite]

Hi,

try writing expression in the sorting.

[dcd123456]

Hi

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

regards