2 Replies Latest reply: Sep 28, 2016 8:18 AM by edmund lo RSS

    Additional bar shows in bar chart

    edmund lo

      Hi all,

      I am new to qlikview but I encounter a problem in creating a bar chart. I want to display the sales of last 24 months in a bar chart by using

       

      =left(aggr(MaxString({<[SalesDate] = {'>=$(v24Months)' }>}[anotherDateColumn]), Year, Month),4)&right(aggr(MaxString({<[SalesDate] = {'>=$(v24Months)' }>}[anotherDateColumn]), Year, Month),2)

       

      to create a dimension for displaying the sales of last 24 months

       

      screenshot.PNG

      However, there is additional bar displaying in the last.


      i am unable to understand this through help also. Thank you