Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

screenshot.PNG

However, there is additional bar displaying in the last.


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

1 Solution

Accepted Solutions
Highlighted

Re: Additional bar shows in bar chart

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

Capture.PNG

View solution in original post

2 Replies
Highlighted

Re: Additional bar shows in bar chart

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

Capture.PNG

View solution in original post

Highlighted
Not applicable

Re: Additional bar shows in bar chart

It is work! Thank you.