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

    Value inside bar chart

    Paul Damen

      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