Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ivan_will
Partner - Creator II
Partner - Creator II

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

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 ?

6 Replies
ivan_will
Partner - Creator II
Partner - Creator II
Author

?

ivan_will
Partner - Creator II
Partner - Creator II
Author

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

ivan_will
Partner - Creator II
Partner - Creator II
Author

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

dcd123456
Creator
Creator

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

Hi

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

regards