14 Replies Latest reply: Dec 13, 2016 11:42 PM by kalyani vintha1 RSS

    Value inside bar chart

    Paul Damen



      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,




      I attached a print screen off the chart