topic Re: Cut Bar Chart in QlikView

Cut Bar Chart

Anonymous — Mon, 02 Feb 2015 18:39:11 GMT

I have seen a cut bar chart before, but I did not have access to how it was done. I have a bar chart where on many selection, the bar chart goes through the top of the chart. The user wants a chart that is static up to a certain point, but that shows the value if past that point. Can this be done? The chart below can get to 200% and higher. What I saw in the chart I am trying to replicate looked to be some sort of offset or break in the middle of the line, then it went up to the total.

Here is a sample of the chart:

Thanks,

Justin

Re: Cut Bar Chart

saurabh5 — Mon, 02 Feb 2015 19:50:50 GMT

Hi Justin,

you can set your static maximum as 180% in the graph, that may work.

Regards

Saurabh

Re: Cut Bar Chart

Anonymous — Mon, 02 Feb 2015 19:54:29 GMT

Saurabh,

I have tried that, but when the number goes over 200% the data point at the top no longer shows, which they would like to see under all circumstances while staying static.

Re: Cut Bar Chart

sujeetsingh — Mon, 02 Feb 2015 22:46:40 GMT

Use static max

and even enable scroll bars.

Re: Cut Bar Chart

Tue, 03 Feb 2015 01:42:34 GMT

Have you tried setting the data point location to the axis?

Re: Cut Bar Chart

Anonymous — Tue, 03 Feb 2015 13:51:56 GMT

Rick,

I hadn't thought of that, good idea and I will check with the user if that will cover their requirement. Still wondering if anyone has heard of the bar chart that I am describing. The chart was similar to mine, but in the middle of the longer bars, there is a cutoff point, like a zig zag line, with a space, and then the bar continues. This was used to cover a long interval from 0 and whatever number they ended at. Has anyone seen this?