Discussion board where members can get started with Qlik Sense.
I have a scatter plot with several measures for the x and y axis. I want the legend to be coloured according to the value of x-axis value minus y-axis value.
If the user changes selects an alternative x / y axis measure then the legend is automatically updated to reflect this.
Any help much appreciated.
Go to Solution.
Hi Matt, maybe setting color by expression and using column(1) to refer to x-axis and column(2) to y-axis, so it can be something like:
If(column(1)-column(2)>0, Red(), Green())
Thanks Ruben - that worked great! I added column 1 - column 2 as a measure and used the diverging classes colour scheme.