Discussion board where members can get started with QlikView.
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.
So if I select Mumbai, gauge should show what value 6 or 2 or 10?
|Workstation Number||Allocated||Available||Blocked||(blank)||Grand Total|
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