topic Re: How Can I Change the Color? in QlikView

How Can I Change the Color?

pnn44794 — Sat, 12 Oct 2019 23:16:25 GMT

Hello:

I have thermometer chart using the following expression and I would like to make the "Finance*", Implementation, Confidence = {High} segment to be a light green and the third Sum to be Yellow. Is there a way to do that?

As always, thanks in advance for any and all help.

Re: How Can I Change the Color?

Anil_Babu_Samineni — Sat, 30 Dec 2017 01:51:13 GMT

It would be better if you provide something? 2nd-green and 3rd-yellow then what about first one?

Re: How Can I Change the Color?

pnn44794 — Sat, 12 Oct 2019 23:17:30 GMT

Hello Anil:

Thanks for the reply.

Re: How Can I Change the Color?

Anil_Babu_Samineni — Sat, 30 Dec 2017 02:10:52 GMT

I understand your intend initial stage only. But, How we can offer without sample. If we can check something then it would be great to you and saves my time. To better, clear i believe you need 2 gradients at a time.

Re: How Can I Change the Color?

pnn44794 — Sat, 12 Oct 2019 23:18:15 GMT

My apologies Anil. I think I get it now.

Re: How Can I Change the Color?

Anil_Babu_Samineni — Sat, 30 Dec 2017 02:42:07 GMT

I would expect some QVW? Anyway, Try a luck

Pick(Match(Num(Sum({$<FB_Phase = {Booked}>}RangeMax([FB_Finance Confirmed 2017 Savings], 0)/1000000) + Sum({$<Phase = {'Finance*', Implementation}, Confidence = {High}>} [Estimated Save]) /1000000

+ Sum({$<Phase = {Concept, Design, Implementation}, Confidence = {Low, Med}>} [Estimated Save]) /1000000 ,'$###0'), '>$0','<$180.6', '>$180.6', '<$195.2', '>$195.2', '<$218.1'), DarkGreen(), DarkGreen(), LightGreen(), LightGreen(), Yellow(), Yellow())

Re: How Can I Change the Color?

pnn44794 — Sat, 30 Dec 2017 02:54:41 GMT

Many thanks Anil, but it’s not my lucky night. I tried your expression and the thermometer disappears. I appreciate you trying without a lot of info. I’ll look into getting some sample data (QVW) tomorrow that I can post which would not compromise anything, and yet, give you enough info to try and find a solution (and I’ll keep trying as well). Thank you again.

Re: How Can I Change the Color?

Anil_Babu_Samineni — Sat, 30 Dec 2017 02:58:58 GMT

You should write this as BG color? Are you?

Re: How Can I Change the Color?

pnn44794 — Sat, 30 Dec 2017 03:09:41 GMT

By BG, I assume you mean RGB. That is the way I want to write it, but I’m not sure how to integrate the colors into the following expression to do so. The first Sum should be dark green. The second Sum should be light green and the third Sum should be yellow.

=Num(Sum({$}RangeMax(, 0)/1000000)

+ Sum({$<Phase = {'Finance*', Implementation}, Confidence = >} ) /1000000

+ Sum({$} ) /1000000 ,'$###0')

Re: How Can I Change the Color?

Anil_Babu_Samineni — Sat, 30 Dec 2017 03:12:50 GMT

Expression seems wrong to me

Re: How Can I Change the Color?

pnn44794 — Sat, 30 Dec 2017 03:39:05 GMT

The expression gives me the amount that has been booked (first Sum – dark green), the amount that looks like it will get booked (second Sum – light green) and then everything else that is outstanding that may or may not get booked (third Sum - yellow). Make sense? The expression does what it’s supposed to do, except how I do change the thermometer colors to coincide with each Sum (3 sums / colors)?

Re: How Can I Change the Color?

pnn44794 — Sat, 30 Dec 2017 03:48:05 GMT

Anil, I’m going offline. If or should you respond, I promise I will get back to you tomorrow. Again, I appreciate your assistance.

Re: How Can I Change the Color?

Anil_Babu_Samineni — Sat, 30 Dec 2017 15:46:33 GMT

Looks sense? May be share sample to investigate. Tomorrow also fine

Re: How Can I Change the Color?

pnn44794 — Sat, 12 Oct 2019 23:19:44 GMT

Hello Anil:

My apologies for the delay (fighting a bad cold and feeling like crap, anyway.......).

Re: How Can I Change the Color?

Anil_Babu_Samineni — Sun, 31 Dec 2017 11:49:39 GMT

Can you try this?

ColorMix2 (if(rangemin('$218.1',rangemax(Num(Sum({$<FB_Phase = {Booked}>}RangeMax([FB_Finance Confirmed 2017 Savings], 0)/1000000) +

Sum({$<Phase = {'Finance*', Implementation}, Confidence = {High}>} [Estimated Save]) /1000000 +

Sum({$<Phase = {Concept, Design, Implementation}, Confidence = {Low, Med}>} [Estimated Save]) /1000000 ,'$###0'),'$180.6'))<'$195.2',

-Sqrt(-(rangemin('$218.1',rangemax(Num(Sum({$<FB_Phase = {Booked}>}RangeMax([FB_Finance Confirmed 2017 Savings], 0)/1000000) +

Sum({$<Phase = {'Finance*', Implementation}, Confidence = {High}>} [Estimated Save]) /1000000 +

Sum({$<Phase = {Concept, Design, Implementation}, Confidence = {Low, Med}>} [Estimated Save]) /1000000 ,'$###0'),'$180.6'))-'$195.2')/('$195.2'-'$180.6')),

Sqrt((rangemin('$218.1',rangemax(Num(Sum({$<FB_Phase = {Booked}>}RangeMax([FB_Finance Confirmed 2017 Savings], 0)/1000000) +

Sum({$<Phase = {'Finance*', Implementation}, Confidence = {High}>} [Estimated Save]) /1000000 +

Sum({$<Phase = {Concept, Design, Implementation}, Confidence = {Low, Med}>} [Estimated Save]) /1000000 ,'$###0'),'$180.6'))-'$195.2')/('$218.1'-'$195.2'))),

ARGB(255, 255, 0, 0), ARGB(255, 0, 255, 0), ARGB(255, 255, 255, 0))

Re: How Can I Change the Color?

pnn44794 — Sat, 12 Oct 2019 23:20:47 GMT

Hello Anil:

I tried the above expression.

Re: How Can I Change the Color?

pnn44794 — Sat, 12 Oct 2019 23:21:51 GMT

Ok.

Re: How Can I Change the Color?

Anil_Babu_Samineni — Mon, 01 Jan 2018 05:11:01 GMT

Checking ...!

Re: How Can I Change the Color?

Anil_Babu_Samineni — Mon, 01 Jan 2018 05:59:13 GMT

I didn't get thru Work. I will wish to learn from cleveranjos‌

Re: How Can I Change the Color?

pnn44794 — Sat, 12 Oct 2019 23:22:52 GMT

Hello Anil:

I'm not sure I understand your reply. My apologies.