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

    Additional bar shows in bar chart

      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



      However, there is additional bar displaying in the last.

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