I have created butterfly chart in qlikview(plz see attachement).
My requirement is to show all dimension values on x axis .if data is not available for that selected dimension value then it should display zeros. So i have disabled 'supress null' and enabled 'zeros on bars' in presentation tab,also i enabled 'show all values' in Dimension tab.
This is working fine if my expression is positive, and is also working if my expression is negative(able to see all dimension values) but zeros are not getting displayed if data is not available for negative expression.
I have created dummy test.qvw and dummy data (attached).
Is there any way to display zeros for negative expression.