topic Re: Mini Linear Gauge - more than one color in QlikView

Mini Linear Gauge - more than one color

Wed, 15 Mar 2017 11:53:35 GMT

Hello every wea, collegs!!!

I need you help.

How I can get next view (Mini Linear Gauge inside straight table):

I find how do it with one colors, but with two and more colors i dont find.

Thank you very much in advance!

Re: Mini Linear Gauge - more than one color

Frank_Hartmann — Wed, 15 Mar 2017 19:09:35 GMT

please upload a sample which shows your problem.

i guess then you will get a working solution/proposal much faster.

Re: Mini Linear Gauge - more than one color

vishsaggi — Wed, 15 Mar 2017 19:28:47 GMT

Not sure about your Mini Gauge expression but using that try this as shown: Change your colors accordingly.

Re: Mini Linear Gauge - more than one color

Thu, 16 Mar 2017 10:09:38 GMT

see attach above

Re: Mini Linear Gauge - more than one color

neha_shirsath — Thu, 16 Mar 2017 10:18:49 GMT

Hi,

Is there any condition for color code?

In provided image seems that on >0 values color code is change..is it like that?

Thanks,

Neha

Re: Mini Linear Gauge - more than one color

Thu, 16 Mar 2017 10:21:04 GMT

Thank you very much for your answer!!!

Unfortunately,

In your case, we get bar (painted cells) same size, but I need size of bar depend on value expression.

Re: Mini Linear Gauge - more than one color

Thu, 16 Mar 2017 10:26:14 GMT

Yes, i thought about it too! I tried to use calculation colors in property of segment linear gauge, but it is not working. May be i am something doing not right....

Re: Mini Linear Gauge - more than one color

vishsaggi — Thu, 16 Mar 2017 16:04:05 GMT

Can you share your sample app to look into and work on please ?

Prepare your sample example file using this:

Preparing examples for Upload - Reduction and Data Scrambling

Re: Mini Linear Gauge - more than one color

Frank_Hartmann — Thu, 16 Mar 2017 16:11:30 GMT

hi,

see attached file.

hope this helps

Re: Mini Linear Gauge - more than one color

Thu, 16 Mar 2017 19:41:21 GMT

attached!!!

Re: Mini Linear Gauge - more than one color

Thu, 16 Mar 2017 19:46:47 GMT

Thanks very much! I read here, that in this case(with two columns) - have a problem in web. I look for decision with display positive and negative values in one column separated colors ( as on the picture above)....

Re: Mini Linear Gauge - more than one color

vishsaggi — Thu, 16 Mar 2017 20:29:49 GMT

Try this? I am not sure but in Mini Guage chart we cant have different colors for the bars. This is a work around i am attaching. Let me know if that helps.

Re: Mini Linear Gauge - more than one color

Fri, 17 Mar 2017 15:04:19 GMT

Hello, thank you, but it is not thing which i need. Probably, it impossible implement decision as in a picture

Re: Mini Linear Gauge - more than one color

vishsaggi — Fri, 17 Mar 2017 15:24:03 GMT

Did you try what Frank has shared with you ? The QVW file ?

Re: Mini Linear Gauge - more than one color

Fri, 17 Mar 2017 16:25:48 GMT

Yes! It is one of possible decisions, but I houpe to find decision where positive and negative values into same column (as in a picture).

Re: Mini Linear Gauge - more than one color

Fri, 17 Mar 2017 16:42:39 GMT

Wow! I looked closely at Frank's QVW - this is the solution that I needed!!! I just corrected it a little bit

Re: Mini Linear Gauge - more than one color

Fri, 17 Mar 2017 16:46:04 GMT

Vishwarath! Thanks very much, that focused my attention to Frank's QVW!

Re: Mini Linear Gauge - more than one color

Fri, 17 Mar 2017 16:54:36 GMT

Frank, I looked closely at your QVW (thanks Vishwarath). And if I slightly modify it - I get solution that I needed!!!

And this solution dont have problem in web, unlike solutions that I saw before

Re: Mini Linear Gauge - more than one color

vishsaggi — Fri, 17 Mar 2017 17:14:20 GMT

No problem, Glad it worked.

Re: Mini Linear Gauge - more than one color

Frank_Hartmann — Fri, 17 Mar 2017 18:24:34 GMT

and if you set the text Format to '<B>'

then you will get rid of the ugly vertical white stripes in the 50% Bar 🙂