topic Re: Issue with Data point in Bar Chart in QlikView

Issue with Data point in Bar Chart

Fri, 11 Sep 2015 06:05:05 GMT

Hello everyone,

We have a business requirement to plot a waterfall chart.

I have created a bar graph which acts like a waterfall chart showing data
points on Bars. Chart is very dynamic showing hundreds of scenarios for various
filter selections. There are negative and positive values having its high range
(for example:-45000,45000) and also small values like 1,2. When we try to plot this
in bar chart, values are not visible completely.(as shown in picture)

And we should not show values in center of bars. I have shown a particular
scenario,

How can we handle this overflow of graph?

Approaches tried:

1)Increasing the length of the graph(Since data are at both ends, we are not
able to achieve it)

It would be helpful if someone answers it.

Thank you in Advance.

Re: Issue with Data point in Bar Chart

manojkulkarni — Fri, 11 Sep 2015 06:12:13 GMT

Please can you post your application, so it will be easy to have look at it.

Re: Issue with Data point in Bar Chart

Fri, 11 Sep 2015 06:32:35 GMT

Hi Manoj,

It is a client application. So, can't share it. But let me check if I can share replica of same application.

Thanks

Re: Issue with Data point in Bar Chart

jonathandienst — Fri, 11 Sep 2015 07:04:12 GMT

Qv will not show the values inside the bar if the bar size is too small. You could place the values above the bar or on the axis.

You have two options

manually/dynamically scale the chart to make the values visible. Scale the bars with an expression that also allows for some space above and below the largest positive and negative values. (=Min(Aggr(<chart expression>, <chart dimensions>))
place the values on the x - axis.

Re: Issue with Data point in Bar Chart

Fri, 11 Sep 2015 07:08:28 GMT

Hi Jonthan,

We are not showing values inside bar. Showing above the bar. Because of dynamic scale of bar chart, We are not able to fix max size of scale and values are hiding under axis.

Can you help me out for that?

Thanks

Re: Issue with Data point in Bar Chart

jonathandienst — Fri, 11 Sep 2015 07:10:12 GMT

See more detailed reply above