Discussion board where members can get started with Qlik Sense.
I want to color column in a table based on SIGN and VALUE using Colormix2.
I can't figure out how to calculate Rank for negative numbers and No of rows where values are Negative and Positive. All this values are inputs for Colormix2 function.
Having slept with this over the night, worked out the solution
colormix1( rank(total fabs(column(X)))/NoOfRows(total), if(column(X)>0,green(),red()),white())
thank you, but this does not take into account that positives should be gradient green and negatives - gradient red, with zero as white. I have posted the solution above and it works