Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY

How to - Double layout ("Sausage") gauge

robert_mika

How to - Double layout ("Sausage") gauge

The native  QV gauges are not very sexy but you can give them little makeover.

Please see below one on how to do that

(you can find out more her

Dislike gauge charts? You may want to give them a second chance)


The idea here is to have our scale started at 12 am (or pm).

We will need two gauges precisely layout out one on another.

The first gauge is just a circle,  the second will hold calculation and segments.

Advice:

Turn on the " Design grid" option.

Untitled.png

It is very helpful when deciding upon the size of the chart or adjusting the layout.

First Gauge

Press right button anywhere on the tab and from option choose "Create New Sheet Object.." and then "Chart..."

a) Tab : General :-

Choose gauge from the chart options.

b) Dimension:

Skip

c) Expressions:

Add '1' as expression

Capture.JPG

d) Sort:

Skip

e) Style:

Choose the first top left corner chart

Capture.JPG

f) Presentation:

Fallow the picture below:

Capture.JPG

g) Actions:

Skip

h) Colors:

The  "Color Background" and the "Frame Background " "Transparency" must be set to 100%

i) Layout:

The "Use Borders " box must be empty

j) Caption:

The "Show Caption" box must be empty

The final result is a  blue circle.

Capture.JPG

Second gauge


Points a-e

(Follow instruction on first chart)


f) Presentation:

Follow the picture below.

Where Segment 1 Lower Bound is 0  and color is Blue and Segment 2 Lower Bound is is your expression

(in this example only decimal number is use but normally you will need to enter an expression in form x/y)

and the color is transparent.

Add Text in "Text in Chart"  option and format it as %.

Segment 1Segment 2
Capture.JPGCapture.JPG

Points g-j

Follow instruction for the first chart.


The final result:

Capture.JPG


And the two gauges joined together:

Capture.JPG

and a small visualization

Capture.JPG




----------------------------


Did You like it?

2015-06-23_070015.png


Feeling Qlikngry?

How To /Missing Manual(18 articles)


Attachments
Comments
manojkulkarni
Partner
Partner

Nice presentation of Guage chart.

0 Likes
arulsettu
Master III
Master III

excellent idea...

0 Likes
Not applicable

Very great idea

0 Likes
taha_mansoor
Contributor III
Contributor III

Robert_Mika‌Very useful stuff, thanks for sharing. I tried it and got one issue, on layout tab I can't see 'Use Borders' box. In fact, several other options are missing. In your qvw, I can see the those option which you mentioned above like 'Use Borders' box . Where am I going wrong ?  Please see the picture below:

layout tab.png

Taha

0 Likes
jolivares
Specialist
Specialist

Good idea, but if your first gauge is just for create the circle, you can create with text object with this characteristics and the put the gauge over it.

Capture.PNG

simondachstr
Luminary Alumni
Luminary Alumni

Jolivares ...or a simple text object with an embedded picture.

0 Likes
robert_mika

You are right but once you start to resize the the picture you will lose some control on the quality of the object

robert_mika

Good idea.

0 Likes
robert_mika

Go first to Settings -->Document Properties -->General and turn on Advance Mode under Styling

Capture.JPG

0 Likes
taha_mansoor
Contributor III
Contributor III

Robert_Mika‌ Thanks, it appeared.

Version history
Revision #:
1 of 1
Last update:
‎2015-11-22 08:59 AM
Updated by: