Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

How Can I Change the Color?

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.

1 Solution

Accepted Solutions

Re: How Can I Change the Color?

Got it.. It won't doable with QT Tube/Thermometer. Instead, I used 3rd Look and make some width reduce to get exact. But, Work around i got finally like below

Capture.JPG

Note - If applicable please mark it as helpful and flag correct answer which you satisfy the answer.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

37 Replies

Re: How Can I Change the Color?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: How Can I Change the Color?

Hello Anil:

 

Thanks for the reply. 

Re: How Can I Change the Color?

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.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: How Can I Change the Color?

My apologies Anil.  I think I get it now.

Re: How Can I Change the Color?

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())

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: How Can I Change the Color?

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?

You should write this as BG color? Are you?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: How Can I Change the Color?

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?

Expression seems wrong to me

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)