Skip to content

Instantly share code, notes, and snippets.

@ralfbecher
Created February 12, 2016 18:49
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/5228f9f44f27938b8246 to your computer and use it in GitHub Desktop.
Save ralfbecher/5228f9f44f27938b8246 to your computer and use it in GitHub Desktop.
QlikView Row-based Transparent Colors
// can be used in scatter chart to have persistend color for dimensions and nice opacity for overlapping bubbles:
=argb(180,
subfield(textbetween(color(RowNo()),'(',')'),',',1),
subfield(textbetween(color(RowNo()),'(',')'),',',2),
subfield(textbetween(color(RowNo()),'(',')'),',',3))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment