How to Create Bullet Charts / Graphs

[#1]

Hi All,

Can I know does QlikView support to make a bullet chart / graphs like below? How to create it?

Thank you, All

[#2]

There are a number of steps involved. First you have to create a gauge chart.

orientation : horizontal

Do the gauge settings now:

Max:  Usually 120% of your expression. e.g. Sum(Revenue) *1.2

Indicator, Model

Show Needle

Style

Line

Switch of autowidth segments

Hide Segment boundaries, Gauge Outlines

Create 3 segments or more

Segment1 lower bound => 0.0

             2  lower => 0.5

             3 => 0.9

give relevant colors

Finish

[#3]

Now add a new Bar chart

no dimension, but add your expression sum(Revenue)

Orientation : Horizontal

Forced 0

Hide Axis both switched on

static max again 120% of your measure

goto color, set transparency to 100%

Layout tab: set shadow to No shadow

border width to 0

layer should be Top

caption turned off

finish

Emboss bar chart over Gauge chart.

Job done.