topic Re: Value inside bar chart in QlikView

Value inside bar chart

pauldamen — Thu, 22 Dec 2011 12:58:09 GMT

Hi,

If have a bar chart in Qlikview which on the x axis shows months and the bars display actual sales and a bar estimated sales. I have the showing values switched off for the estimated sales. I only want to show these values if the month is in the future, this I achieved with the formula:

=If(sum({<Version = {'Actual'}>)[ExpenseAmount}, 1, 0).

This will show the value ON TOP off the bar, but I want to have the value INSIDE the bar. In presentation the box for showing values inside is checked, I also tried to change the numbers in the formula above but that didn't helped.

Can someone help me with this?

Thanks a lot!

Kind regards,

Paul

I attached a print screen off the chart

Value inside bar chart

matt_crowther — Thu, 22 Dec 2011 13:53:37 GMT

Try this: Chart Properties > Presentation > Check 'Plot Values Inside Segments'.

Works for me.

All the best,

Matt - Visual Analytlcs Ltd

Value inside bar chart

SunilChauhan — Thu, 22 Dec 2011 13:57:47 GMT

use below property

chart properties-> expression -> value on data point-> presentation -> check verticle and

also check Plot values inside Segments

hope this help

Value inside bar chart

pauldamen — Thu, 22 Dec 2011 15:11:10 GMT

The Plot values inside segments box is already checked. But somehow with the expression attached to the showing value this doesn't work, therefor I was looking for other ideas.

Re: Value inside bar chart

O11235 — Mon, 07 Jul 2014 11:53:46 GMT

The Verticle box function seems to be disabled when you use a grouped bar chart. If you've selected a grouped bar chart look or similar under 'Chart Properties -> Style -> Look'. You need to consider one of the other options and then go to Chart Properties->Presentation->Values on Data Points and select the Verticle check box. This of course after activating Values on Data Points under Expressions in the Chart properties.

Re: Value inside bar chart

amit_saini — Mon, 07 Jul 2014 12:10:11 GMT

Hi Paul,

Please see below:

Go to Presentation tab->enable Plot Values Inside Segments and you will get value like in image below.

Thanks,

Re: Value inside bar chart

c_gilbert — Mon, 07 Jul 2014 14:17:58 GMT

I had the same problem of the value not showing even though the box was ticked.

It seemed to only show when the expression for which I wanted the value to show, was promoted to the top of the list of expressions (so it is the first one).

Not sure if this is a bug, but it worked for me. Good luck.

Re: Value inside bar chart

Tue, 28 Oct 2014 13:45:58 GMT

Hi,

Try this,

Chart Properties
- Expressions Tab > in Display Options Section > Check Values on Data Points - so that the values are displayed
- to have the values inside the bar Horizontally : Presentation tab > Under Values on Data Points Section > Check Plot Values inside Segments and set Max Values Shown as 100.
- To have the values inside the bar Vertically : Presentation tab > Under Values on Data Points Section > Check Plot Values inside Segments & Vertical and set Max Values Shown as 100.

This will work now

Regards,

Aswinkumar B

Re: Value inside bar chart

Tue, 26 May 2015 11:10:20 GMT

good tip thanks sir!

Re: Value inside bar chart

Tue, 13 Dec 2016 13:40:56 GMT

Hi,

I have done the small example in that you can see I take dimension as Country and Expression as Sum of sales.

You can show the values on the bar chart as well as the inside the bar chart.

Please find the attached screen shot for your reference

Regards,

Yogesh J

Re: Value inside bar chart

Tue, 13 Dec 2016 13:54:46 GMT

Check the vertical from the above image you will get the values inside segment in vertical

Re: Value inside bar chart

Anonymous — Tue, 13 Dec 2016 14:14:29 GMT

Hi Paul,

This is what you posted:

=If(sum({<Version = {'Actual'}>)[ExpenseAmount}, 1, 0).

in this...i observed

unexpected bracket opened before the 'ExpenseAmount'

Re: Value inside bar chart

Anonymous — Tue, 13 Dec 2016 14:17:35 GMT

Try like this:

=If( sum( {<Version = {'Actual'}>} ExpenseAmount ), 1, 0).

Re: Value inside bar chart

Tue, 13 Dec 2016 18:37:01 GMT

You are replying to a topic from 5 years ago

Re: Value inside bar chart

Anonymous — Wed, 14 Dec 2016 04:42:50 GMT

hooo k,

i didn't find the correct answer in this discussion,

that why i made a reply for this