Pin And Needle Diagram for QlikView (with native ComboChart)

    A customer asked me whether a "Pin and Needle Chart" would be possible with QlikView (for example: Hichert information design recommends this chart type to represent percentage deviations).

     

    Well, that chart isn't available at first sight. It requires tree layers of a Combo Chart together

    1. A dot layer to show the needle heads with a background color formula (positive values are green, negative are right)
    2. A box plot layer with a very untypical box size of 0 and an "upper whisker" in case of positive values, and a "lower whisker" in case of negative values
    3. a bar chart layer with a bar color of ARGB(0,0,0,0)  (means: completely transparent). Only purpose of this bar layer is the "show values on data points" flag which will print the value next to the needle head. I also put a non-breaking space CHR(8192) before and after the value, so that it makes a little space between the number and the needle head.

     

    Example app is attached.

     

    Pin and Needle.png

     

    Screenshot 2016-03-03 22.47.01.png

    See also QlikView BulletChart made with native Combo-Chart