Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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

Re: Additional bar shows in bar chart

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

Capture.PNG

2 Replies

Re: Additional bar shows in bar chart

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

Capture.PNG

Not applicable

Re: Additional bar shows in bar chart

It is work! Thank you.