Value inside bar chart

[pauldamen]

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

[#2]

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

[Anonymous]

Hi Paul,

This is what you posted:

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

in this...i observed

unexpected bracket opened before the 'ExpenseAmount'

[Anonymous]

Try like this:

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

[#5]

You are replying to a topic from 5 years ago

[Anonymous]

hooo k,

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

that why i made a reply for this