Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Partner
Partner

Guagechart help

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

1 Solution

Accepted Solutions
Highlighted

Re: Guagechart help

May be something like attached

Capture.PNG

View solution in original post

8 Replies
Highlighted
Contributor

Re: Guagechart help

Hi

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

Highlighted
Partner
Partner

Re: Guagechart help

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

Highlighted
Contributor

Re: Guagechart help

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

       

Workstation NumberAllocatedAvailableBlocked(blank)Grand Total
Chennai522 9
Mumbai622 10
Pune513 9
(blank)
Grand Total1657 28
Highlighted
Partner
Partner

Re: Guagechart help

If you select Mumbai

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

and availble will be Red

Highlighted
Contributor

Re: Guagechart help

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

Or

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

Highlighted
Partner
Partner

Re: Guagechart help

it will be 8

Highlighted
Contributor

Re: Guagechart help

Sorry

I can't figure out, maybe someone help!

stalwar1

bohravanraj

Highlighted

Re: Guagechart help

May be something like attached

Capture.PNG

View solution in original post