topic How to create this chart in Qlikview? in QlikView

How to create this chart in Qlikview?

Tue, 15 May 2012 13:32:02 GMT

HI All,

Please find below the below figure,I'M facing problem creating the chart column in this chart.Do anyone have an idea how can i re-create this chart in qlikview.Thank you.

How to create this chart in Qlikview?

jagannalla — Tue, 15 May 2012 13:39:06 GMT

Kevincool,

It all depends on your data, expression you written for Chart label. In Expression Tab select your chart expression and select minichart in Representation -> Mini Chart Settings ->Select your dimension here and choose your Mode -> Ok

How to create this chart in Qlikview?

Tue, 15 May 2012 15:48:38 GMT

I know what your talking about...The modes in mini chart does not consist of the requirements in my chart.Instead of mini chart we have to use linear gauge but i am unable to do this with linear gauge.

How to create this chart in Qlikview?

Tue, 05 Jun 2012 16:26:26 GMT

Hi kevin,

did you succeed?

What about an example QV-App? Or some examples in excel from what you want to achieve. Then give the community a chance.

Lets try,

Roland

Re: How to create this chart in Qlikview?

Oleg_Troyansky — Tue, 05 Jun 2012 17:50:30 GMT

I don't think a chart that is EXACTLY like the one presented, is possible to reproduce in QlikView.

The closest to it would be a Gauge inside a straight table, however the Gauge can't have variable segment boundaries within the same chart - all the segment boundaries are calculated once for the whole chart and can't vary in each line.

In order to do it in QlikView, you'd have to "normalize" all the segments across the lines, and deven then you might have to overlap a number of transparent charts in order to reproduce all the "bells and whistles".

Perhaps a good candidate for an Extension object?

Oleg

Re: How to create this chart in Qlikview?

Wed, 06 Jun 2012 13:50:37 GMT

Hi Oleg,

I agree with you, you can't allways rebuild exactly every feature of other tools (esp. excel).

But recently I had the challenge to "copy" a straight table chart which includes a bar in every line for some measures. My nearest QV-Version looks like the attached pic. (Put the Delta bars into the straight table)

I tried in vain using linear gauges because of the reasons you mentioned above.

Any way: I think it is a real and reproducible requirement.

Re: How to create this chart in Qlikview?

Sun, 24 Jun 2012 19:33:59 GMT

hi,

I know my reply is late because I gave up creating this chart as it cant be done in qlikview.QV calculates segments in linear gauge the same for all dimension values although the needle varies!.This chart was done in excel by my client.I found an alternate way although not the correct alternative,it is to display only ONE VALUE of the dimension so that the segments change with the selection.

i have tried with the trellis chart option,came somewhere near to the goal but no the chart cant be done just

as it is in qlikview.Thanks all for ur comments.

Re: How to create this chart in Qlikview?

javier_florian — Wed, 23 Jul 2014 14:24:37 GMT

Hi Kevin,

After two years, I faced the same request... and I was combining a mini-graph (spark-lines) with a charts but this is complex aligned the dimension (Organization).

Do you have a workaround?

-JFlorian

Re: How to create this chart in Qlikview?

Fri, 24 Jul 2015 09:38:07 GMT

Hi Javier, Any luck! Regards, Manish Virmani

Re: How to create this chart in Qlikview?

jcamps — Wed, 04 Nov 2015 11:16:30 GMT

Hi, if you can work on web view, you can use the google static charts API to create inline graphical representations of your data in a grid, like so:

For example see this URL:

https://chart.googleapis.com/chart?cht=p&chd=t:20,80&chs=100x100

It's quite easy, the goal here will be to build a URL-like string, that contains the numbers for each dimension in the table you want to plot. You have to set the expression to be shown as . For example:

='https://chart.googleapis.com/chart?cht=p&chd=t:' & value & ',' & (100-value) & '&chs=100x100

Whereas something like this will let you create a bullet chart that seems closer to what you need.

http://chart.apis.google.com/chart?cht=bhs&chs=150x30&chd=t:70&chm=r,ff0000,0,0.0,0.5|r,ffff00,0,0.5,0.75|r,00A000,0,0.75,1.0|r,000000,0,0.8,0.81&chco=000000&chbh=10

Some tweeking will be needed (for example, some scenarios need a concat(aggr...)), but that should solve your problem. Also note that this API is unsupported by Google any more, but still running and no plans on taking that out. Depending on how critical your environment, this might not be acceptable.

See or copy code from attached example,

Cheers!

Re: How to create this chart in Qlikview?

jcamps — Wed, 04 Nov 2015 16:06:49 GMT

Correcting myself, this solution does work on ajax, plugin and desktop - as long as you have an internet connection available.

Re: How to create this chart in Qlikview?

Thu, 05 Nov 2015 09:55:55 GMT

But Still the segments seems to be the same for the entire dimension.

Re: How to create this chart in Qlikview?

jcamps — Thu, 05 Nov 2015 14:52:06 GMT

In the example I only changed the black bar, but you can as easily change the segments / colors, vertical marker, even image size, bar length or width, or whatever. Think of each image (cell in a row) as a text that you can build from that dimension's data, so yes, the segments can be different for each row, like so:

Re: How to create this chart in Qlikview?

vishnus85 — Sun, 26 Mar 2017 17:10:41 GMT

Hi Jordi,

Thanks for the solution using google api charts. I had a similar requirement and I am planning to use this. But I noticed that when I turn the 'webview' of my qlik desktop ON, the chart disappear exposing the URL behind. I have an internet connection. The charts render as required in my qlikview desktop when the webview is OFF. Any idea why this is so. Should I change any settings to enable it in webview ? This makes me skeptical of whether this would work when deployed in access point.

Regards,

Vishnu