Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ralfbecher/512f42d5380a84a4acdf to your computer and use it in GitHub Desktop.
Save ralfbecher/512f42d5380a84a4acdf to your computer and use it in GitHub Desktop.
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