Colour by Expression or Colour by Measure

SimonBall — Sat, 16 Nov 2024 17:19:41 GMT

Hello.

I'm building a demo app for a project, and the customer has given me colour codes for targets, red, amber and green. I am OK with building a variable and passing it a measure to return the colour code, however, one of the other charts I built is coloured by measure, using the customers colours from the theme I built.

One of the customers has asked if they can toggle between the target colours and the "nice" colours in the TreeMap chart.

For one, I have to edit the page and set the Appearance:Colours and Legend:Colours=by Expression, and enter the Expression, for the other I have to set it to by Measure, select the measure and select the colour theme.

So I can build two versions of the same chart, pop them in a container, and show them conditionally using a button, but I wondered if any community geniuses had a way to do this just using one chart, and by expression, but being able to create an expression that mimics the by measure mode and selects a colour scheme?

the current expression is toggled using a selector variable:

pick($(vAnalysisPageShowColours),'#8C770E',$(vTargetTVColourCalc_OTIF([OTIF])) )

But could I replace the hard coded colour with an expression that mimics what Qlik Sense does when you select By Measure?

Is there a way to do this?

Re: Colour by Expression or Colour by Measure

Patricia_Silva — Sun, 04 Apr 2021 11:12:32 GMT

Hello @SimonBall do you mean changing by dimension like this article explains?

https://support.qlik.com/articles/000034565

Please let me know 🙂

Re: Colour by Expression or Colour by Measure

SimonBall — Thu, 08 Apr 2021 11:16:16 GMT

Thanks for the link, I'm able to use that option to set colours for dimension options, but I need to be able to toggle between by expression and by measure options and that doesn't seem possible.

topic Colour by Expression or Colour by Measure in App Development

Colour by Expression or Colour by Measure

Re: Colour by Expression or Colour by Measure

Re: Colour by Expression or Colour by Measure