topic Re: Trellis chart with conditional color in QlikView

Trellis chart with conditional color

caio_caminoski — Fri, 15 May 2015 14:16:56 GMT

Hi guys!

I have been working in a trellis chart. But I am having an issue with the conditional colour. My goal is to specify a logic that applies a different color to each chart according to results of their expressions.

I tried using aggr function in the background color and in the presentation tab, but it seems that qlikview does the calculation before and apply the same colour to every chart in the trellis.

In the exemple above I was hoping to get red color for the lower values.

Does someone know if what I want is possible to achieve?

Best Regards!

Re: Trellis chart with conditional color

Gysbert_Wassenaar — Fri, 15 May 2015 15:15:53 GMT

Not afaik. You can either use four separate charts or use two segments:

Re: Trellis chart with conditional color

caio_caminoski — Fri, 15 May 2015 16:52:10 GMT

Thank you for your answer, Gysbert.

I will have to use the trellis feature because the number of charts can change depending on the data.

If someone knows a workaround, please let me know. I would like to have something like the fake image below

Thanks again