Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem with 'Show All Values' in Dimension tab for negative expression.

HI,

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.

Kindly help.

Thanks

1 Reply
Anonymous
Not applicable
Author

Attaching one more file for better understanding of problem:)