topic Re: QlikView and Bullet Graphs/charts in QlikView

QlikView and Bullet Graphs/charts

Or — Mon, 05 Jul 2010 10:01:32 GMT

As most of us know, QlikView does not have native support for Bullet Graphs (as described in Stephen Few's books and website, design document available here ). Workarounds exist for creating a single instance of bullet graphs (described here ), but this is bulky and does not always provide a solution. Unfortunately, it does not appear QlikView plans to add bullet graph functionality (it's not on the QV10 new function list), despite the fact that most of the infrastructure is there (a bullet graph is very similar to the existing gauges, but with an extra fill line).

I wanted to start a discussion with a few related questions:

1) Other than myself, are there (m)any people out there who would like to see bullet graphs implemented in QV?

2) Does anyone have working examples of dashboards using bullet graphs in conjunction with intra-chart gauges? In particular, does anyone have examples overlaying bullet charts on intra-chart gauges with rows wrapped to more than one line?

3) Could someone from QV's R&D chime in with an explanation why this functionality isn't being added, and perhaps an idea of whether we might see it in a future release?

Regards,

QlikView and Bullet Graphs/charts

Mon, 05 Jul 2010 10:08:52 GMT

Hi Or,

1) I would like to see this implemented simply because I think it would be easy to do and at least in a product comparison arena it is better to see that QV does this - e.g. "List of features: x,y,z, and bullet chart" rather than "x, y, z, hmm you can overlay some charts to create the effect".

2) No examples here however I have never been asked to display data in this way.

3) Is it the case that someone saw the feature request and said no, or maybe we should request this feature?

-QB

QlikView and Bullet Graphs/charts

Mon, 05 Jul 2010 11:45:05 GMT

This feature has been discussed and it's a good idea to have it in QV. I guess the only problem is that it has not been prioritized for v10.

QlikView and Bullet Graphs/charts

Or — Mon, 05 Jul 2010 13:24:32 GMT


_qlikbox wrote:
3) Is it the case that someone saw the feature request and said no, or maybe we should request this feature?<div></div>

I have made this feature request, and gotten confirmation that it had been received. I haven't heard about it since - it's not on the QV10 feature list and there's no preliminary QV11 list made public, as far as I know. Perhaps if more people made the feature request, it will get pushed up the priority list (as it stands, it might force me to push a project from QV to other software in order to meet client demands for a large amount of bullet graphs)

QlikView and Bullet Graphs/charts

Wed, 17 Nov 2010 18:36:08 GMT

I agree, a bullet chart conveys a lot of information at a glance - solving the designer's nr1 challenge - screen real estate. This is particularly true to financial statement type data sets where you have actual, budget, previous period, period-to-date all at once, and a simple bar chart is just not enough.

I do hope that someone build an extension in QV10 and share it!

Cheers,

Daniel

Re: QlikView and Bullet Graphs/charts

Mon, 11 Jul 2011 10:20:17 GMT

Hi Or

I use Google Charts to recreate the bullet graph recommended by Stephen Few.

Create a new Straight Table Chart.

Select any dimension (I created a calculated dimenions of =1 and used the hide column in the presentation tab so that it wouldn't display)

Create your expression by copying and pasting the following code into your Expression:

='http://chart.apis.google.com/chart?&cht=bhs'

& '&chs=' & '150x40' // chart size, width x height in pixels

& '&chco=' & '000000' // chart color for the performance bar, 000000 is html hex code for black

& '&chd=t:' & '55' // chart data - CHANGE THIS TO SET THE LENGTH OF THE PERFORMANCE BAR

& '&chbh=' & '5' // chart horizontal bar height, value in pixels

& '&chm=r,' // chart marker r (for horizontal range)

& '000000' // html hex code

& ',0,' // dummy value that is always ignored

& '0.65' // where the marker starts, 0 is the left, 0.5 is the middle - CHANGE THIS TO SET THE COMPARATIVE MEASURE

& ','

& '0.67' // where the marker ends, 1 is the right - CHANGE THIS TO SET THE COMPARATIVE MEASURE

& ',1' // places the marker on top of the performance bar so that it can be seen

& '|r,'

& 'D3D3D3' // html hex code for the first scale band, D3D3D3 is html hex code for light gray - CHANGE THIS TO SET THE COLOUR OF THE FIRST PERFORMANCE SCALE

& ',0,'

& '0,' // where the scale starts, 0 is the left, 0.5 is the middle - CHANGE THIS TO SET THE START OF THE FIRST PERFORMANCE SCALE

& '0.66' // where the scale ends, 1 is the right - CHANGE THIS TO SET THE END OF THE FIRST PERFORMANCE SCALE

& '|r,'

& 'A9A9A9' // html hex code for the second scale band, A9A9A9 is html hex code for medium gray - CHANGE THIS TO SET THE COLOUR OF THE SECOND PERFORMANCE SCALE

& ',0,'

& '0.66' // where the scale starts, 0 is the left, 0.5 is the middle - CHANGE THIS TO SET THE START OF THE SECOND PERFORMANCE SCALE

& ','

& '0.73' // where the scale ends, 1 is the right - CHANGE THIS TO SET THE END OF THE SECOND PERFORMANCE SCALE

& '|r,'

& '808080' // html hex code for the second scale band, 808080 is html hex code for dark gray - CHANGE THIS TO SET THE COLOUR OF THE THIRD PERFORMANCE SCALE

& ',0,'

& '0.73' // where the scale starts, 0 is the left, 0.5 is the middle - CHANGE THIS TO SET THE START OF THE THIRD PERFORMANCE SCALE

& ','

& '1' // where the scale ends, 1 is the right - CHANGE THIS TO SET THE END OF THE THIRD PERFORMANCE SCALE

& '&chxt=x' // chart axis type, to set labels on the x axis

& '&chxl=0:' & '|0|50|100|150' // chart axis labels, 0 is the data index (there is only one set of data we're graphing) and 0, 50, 100, 150 are the labels - CHANGE THIS TO SET THE AXIS LABELS

& '&chxs=0,000000,8' // chart axis style, 0 is the axis index we're referring to, 000000 is the html hex for the color black and 8 is the font size

Then click show as image (thanks Jochem for pointing that out).

Your horizontal bullet chart is ready. Hope this helps.

Kind regards, Shaun

Re: QlikView and Bullet Graphs/charts

Mon, 11 Jul 2011 11:57:34 GMT

and then show as image?

Re: QlikView and Bullet Graphs/charts

Tue, 12 Jul 2011 19:36:35 GMT

In expression panel for Straight Table , go to Display Options. Then choose representation = Image

Re: QlikView and Bullet Graphs/charts

Wed, 13 Jul 2011 06:50:06 GMT

i did this but the cell stays empty (white)

can you upload you qvw with this post?

Re: QlikView and Bullet Graphs/charts

Wed, 13 Jul 2011 18:28:15 GMT

Strange !

Hope it helps to fix your issue.

I'm going to create an application with dynamic variable thanks to the brilliant job of Shaun.

Re: QlikView and Bullet Graphs/charts

Wed, 13 Jul 2011 18:59:21 GMT

Hi Jochem

Are you running QlikView behind a firewall? You may have to open you firewall for HTTP communications.

In the Display Options of the expression tab uncheck Hide Text When Image Is Missing. Do you now have a URL where you should have an image? If you copy this URL to Internet Explorer does it work?

Kind regards, Shaun

Re: QlikView and Bullet Graphs/charts

Mon, 18 Jul 2011 07:46:01 GMT

The attachment from Jean works perfect!

So it''s not a firewall issue, think i made a mistake in the URL

thnx guys!

Re: QlikView and Bullet Graphs/charts

Thu, 21 Jul 2011 11:17:11 GMT

Hi All,

I have just been playing around with Trellis - bullet charts. It seems to work quite well, see the image in attached word doco. I dont have time to put up the QV file sorry due to data confidentialty.

Have others tried this?

Dan

Re: QlikView and Bullet Graphs/charts

Wed, 09 Nov 2011 09:44:37 GMT

Hi All,

It seems Qlikview has taken some steps towards Bullet Chart. I went through the Qlikview 11 demo samples and found one "Extension" example that has Bullet Chart as one of the extension.

Here is the link for the example :

"http://eu.demo11.qlik.com/detail.aspx?appName=Extension%20Examples.qvw"

Hope this solve our issues to some extent.

Regards,

Abhishek