topic Re: How to Create Bullet Charts / Graphs in QlikView

How to Create Bullet Charts / Graphs

Fri, 04 Jul 2014 04:12:03 GMT

Hi All,

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

Thank you, All

Fri, 04 Jul 2014 04:53:13 GMT

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

Fri, 04 Jul 2014 04:56:01 GMT

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.