/QlikView_color_code_percentage_of_max_value.qvs
Created Aug 23, 2015
QlikView color code percentage of max value
| =Replace( | |
| ColorMix2 (if(rangemin(.90,rangemax( Sum(value) / Max({1} TOTAL value),.50))<.75,-Sqrt(-(rangemin(.90,rangemax( Sum(value) / Max({1} TOTAL value),.50))-.75)/(.75-.50)),Sqrt((rangemin(.90,rangemax( Sum(value) / Max({1} TOTAL value),.50))-.75)/(.90-.75))), RGB(255, 0, 0), RGB(0, 255, 0), RGB(255, 255, 0)) | |
| ,'ARGB(255,','RGB(') |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment