Hi guys,
I have one dimension and 2 measures, to colors I need to use colormix.
if(variable1 >= target, rgb(0,20,200), if( variable1 < target, colormix1(rank(total column(1))/ noofrows(total), rgb1,rgb2))))
I'm trying to use the https://community.qlik.com/t5/Qlik-Sense-Documents/Qlik-Sense-Color-Range-Theme-Approach/ta-p/149102...
ColorMix2( (rank(total column(1))/(noofrows(TOTAL)/2))-1 ,rgb1, rgb2,rgb3)
But with no success, how can I change my initial expression to consider another RGB color?