I wanted to get your views and suggestions on how we can achieve the color gradient on a QlikView straight table. Below is the table where I want to color code (gradient) the column CY vs PY.
Below is a sample of how I want this to appear. Please see the color gradient from Blue (positive) to Red (negative).
Below is a snapshot from excel showing how it is done. Can you suggest how we can achieve same in QlikView?
Attached is a sample qvw for testing.
Solved! Go to Solution.
Please take a look at the attached picture. The expression used is =colormix2((Column(5)-Column(4))/Column(4), blue(170),lightred(), white()).
Thanks for taking a shot at this. I don't think it is working as per how it defined in the xls sheet? Did you look at the attached xls snapshot and how the gradient is defined there? I guess I am not seeing a condition which color the cells as in the xls. Am I missing something ?