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)