Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try checking 'Suppress When Value Is Null' on the dimensions tab
Try checking 'Suppress When Value Is Null' on the dimensions tab
It is work! Thank you.