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
- A dot layer to show the needle heads with a background color formula (positive values are green, negative are right)
- 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
- 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.