Additional bar shows in bar chart

[#1]

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

[sunny_talwar · Accepted solution]

Try checking 'Suppress When Value Is Null' on the dimensions tab

[#3]

It is work! Thank you.