topic Re: calculated colors in QlikView

calculated colors

alexpanjhc — Wed, 25 Nov 2020 16:16:04 GMT

Hey guys,

I am struggling over something very simple.

I want to change the color of the linear gauge's arrow (shown below)

I want the arrow change with the formula I have. however, the color would not change.

Is it true that the color will not change by the formula?

thanks!

Re: calculated colors

Or — Mon, 18 Sep 2017 13:33:40 GMT

Switch from "Line" to "Arrow" and you can set the color. "Line" doesn't seem to respect color definitions.

Re: calculated colors

alexpanjhc — Mon, 18 Sep 2017 13:37:02 GMT

Hey

Thanks for the response, but that does not work either.

Re: calculated colors

Or — Mon, 18 Sep 2017 13:40:53 GMT

Are you sure your formula for this is valid?

I just double-checked and it works correctly for me in both regular and fill-to-value mode - note the magenta arrow.

Re: calculated colors

alexpanjhc — Mon, 18 Sep 2017 13:45:19 GMT

sorry maybe I was not clear.

I want that arrow(line) to change say when it is 75% high show red, 30% or higher to show amber and so on as my line gauge is not colored (only one segment)

Does that make sense?

Re: calculated colors

Or — Mon, 18 Sep 2017 13:54:32 GMT

In that case, I'm afraid you're out of luck - as far as I know, the gauge settings are global for the entire expression and aren't re-evaluated per row.

Re: calculated colors

dinuwanbr — Tue, 19 Sep 2017 07:39:45 GMT

Hi alex,

Can you upload a sample if possible?

Rgds,

Tharindu

Re: calculated colors

alexpanjhc — Tue, 19 Sep 2017 13:29:14 GMT

Hi Tharindu

please see attached.

thanks!