topic Re: doughnut Gauge chart in QlikView

doughnut Gauge chart

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

Hi All

Please help i am trying to do doughnut Gauge chart with maybe 3 segments with below details but it doesn't work :

if is 10-50 be green

if is 51-60 be yellow

if is 61-85 be Red

Re: doughnut Gauge chart

neelamsaroha157 — Thu, 12 Jul 2018 13:25:24 GMT

May you are using fill to values in the presentation tab -

and are you overlapping two charts?

Re: doughnut Gauge chart

mandilicious — Thu, 12 Jul 2018 13:49:52 GMT

Hi Neelam

Firstly thanks for your response.i have than done that but i need to it to show in doughnut Gauge

I need it to be like if is 10-50 be green,if is 51-60 be yellow,if is 61-85 be Red but it doesn't work.

Re: doughnut Gauge chart

neelamsaroha157 — Thu, 12 Jul 2018 13:54:01 GMT

Can you share a sample file to play around?

Re: doughnut Gauge chart

mandilicious — Thu, 12 Jul 2018 14:04:06 GMT

Hi Neelam

I have attached below small Qvd.

I hope it will help.

Re: doughnut Gauge chart

neelamsaroha157 — Thu, 12 Jul 2018 14:11:55 GMT

Do you mind sharing the qvw file or can you let me know what fields and calculation you are using for the chart..

Re: doughnut Gauge chart

mandilicious — Thu, 12 Jul 2018 14:18:31 GMT

Hi Neelam

Please receive attached.

Re: doughnut Gauge chart

neelamsaroha157 — Thu, 12 Jul 2018 14:45:02 GMT

Is this what you are looking as output?

It has the bounds as 0-50, 51-60 and 61-100.

Re: doughnut Gauge chart

mandilicious — Fri, 13 Jul 2018 08:07:28 GMT

Neelam

Yes but i need to display only color of the current percentage without show Needle.e.g if its 0-50 is suppose to display green color only and the other part grey/white maybe and if it is 51-60 it will show Green and Yellow not red,if is 61-100 it will show all color cause it obviously passed all colors.

I hope i am making sense.

Thanks

Re: doughnut Gauge chart

neelamsaroha157 — Fri, 13 Jul 2018 14:17:04 GMT

Is this how you want it to be?

Re: doughnut Gauge chart

mandilicious — Wed, 18 Jul 2018 13:40:41 GMT

Hi Neelam

Yes please share the steps.

Thanks you very much.

Re: doughnut Gauge chart

neelamsaroha157 — Wed, 18 Jul 2018 14:09:28 GMT

Here you go.

Re: doughnut Gauge chart

mandilicious — Wed, 18 Jul 2018 14:44:48 GMT

Hi Neelam

Thank you very much for your help,I am having bit of situation why it is only Static not dynamic even when i am putting 61% cause it suppose to show red, your Segments is red when it is 0.61?

It doesn't change as per % or Number?

Please help.

Re: doughnut Gauge chart

neelamsaroha157 — Wed, 18 Jul 2018 15:05:58 GMT

The bounds are static as per your requirement.

For the 'expression' and 'text in chart' I have used static values just to play around. You can replace both these with your desired expression.

The above image shows that when the value of expression is changed to .61, the red bound comes in picture.

Unfortunately, I am not sure where you are facing the challenge.

let me know how I can help better.

Re: doughnut Gauge chart

mandilicious — Thu, 19 Jul 2018 07:35:34 GMT

Neelam

Thank you very very much for being patient with me you are the best.

Problem solved!

Thank you

Re: doughnut Gauge chart

neelamsaroha157 — Thu, 19 Jul 2018 12:45:07 GMT

I am glad it worked out fine . Good luck!