Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
QlikView color code percentage of max value
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))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.