Qlik Community

QlikView Documents

Documents for QlikView related information.

Pin And Needle Diagram for QlikView (with native ComboChart)


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


Very creative. Thanks for sharing this

Valued Contributor II

Thanks Christof, very interesting

Not applicable

Very Good! I used the same approach to visualize my deviations regarding the IBCS. Just a short note: Eliminate the vertical lines and add a reference line. IBCS do not use vertical lines.

2016-03-04 13_44_43-QlikView x64 - [C__Users_lliadx8_AppData_Local_Microsoft_Windows_Temporary Inter.jpg

Valued Contributor II

Very nice, but can't you do something very similar using a chart with error bars, rather than box plots?QV_Pin_Needle_1Chart.PNG

Valued Contributor II

Excellent Post. Thanks for the creativity...

New Contributor III

Interesting One. Thanks for Sharing.

Contributor III


Valued Contributor II

Good work.. very interesting..

Contributor II


Poderia me encaminhar um modelo desse gráfico desenvolvido em barra de erro como disse, e possível.

Tenho um tabela em excel  no painel demostro 6 gráficos de barras, e possível desenvolver esses gráficos de pin agulha com dados em excel?????

Contributor III

Good one.

Thanks for sharing

Version history
Revision #:
1 of 1
Last update:
‎03-03-2016 11:43 AM
Updated by: