Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check the vertical from the above image you will get the values inside segment in vertical
Hi Paul,
This is what you posted:
=If(sum({<Version = {'Actual'}>)[ExpenseAmount}, 1, 0).
in this...i observed
unexpected bracket opened before the 'ExpenseAmount'
Try like this:
=If( sum( {<Version = {'Actual'}>} ExpenseAmount ), 1, 0).
You are replying to a topic from 5 years ago
hooo k,
i didn't find the correct answer in this discussion,
that why i made a reply for this