topic Guagechart help in QlikView

Guagechart help

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

Hi Team,

I need to create gauge chart with 2 colors Green and red and condition is Allocation type = Allocated and Blocked will be green while Blocked will be red. Also i need calculation in the % format.

i am attaching the sample data.

please help.

Suryakant

Re: Guagechart help

thevingo — Mon, 02 Apr 2018 07:20:01 GMT

1. the gauge chart works on numeric values, so what is value/calc in your case.

I think you need to re-consider your use-case

2. Blocked should be Green or Red

Re: Guagechart help

suryakant241187 — Mon, 02 Apr 2018 07:23:06 GMT

count of Allocated and Blocked should be green while count of available should be red

Re: Guagechart help

thevingo — Mon, 02 Apr 2018 07:29:31 GMT

So if I select Mumbai, gauge should show what value 6 or 2 or 10?

Workstation Number	Allocated	Available	Blocked	(blank)	Grand Total
Chennai	5	2	2		9
Mumbai	6	2	2		10
Pune	5	1	3		9
(blank)
Grand Total	16	5	7		28

Re: Guagechart help

suryakant241187 — Mon, 02 Apr 2018 07:33:29 GMT

If you select Mumbai

Then count of Allocated+Blocked will be green( 6+2)

and availble will be Red

Re: Guagechart help

thevingo — Mon, 02 Apr 2018 07:38:06 GMT

but gauge can only show 1 value so either 6 or 8 or 2 or.... but not all 3 values

So you can use 3 separate gauges or text-boxes for Alloc, avail & block

Arrange 3 text boxes, to look like a single gauge chart

Re: Guagechart help

suryakant241187 — Mon, 02 Apr 2018 07:39:26 GMT

it will be 8

Re: Guagechart help

thevingo — Mon, 02 Apr 2018 07:45:17 GMT

Sorry

I can't figure out, maybe someone help!

stalwar1‌

bohravanraj‌

Re: Guagechart help

sunny_talwar — Mon, 02 Apr 2018 09:07:30 GMT

May be something like attached