Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Show all zero values

Hi,

if it's possible that show all zero values in bar chart? Some months doesn't seem but some months shown in the bar chart. How can i show all zero values in bar chart? And why chart shows some months zero others not? Thank you.

Trend 0.png

Version: Qlik Sense February'2018

6 Replies
OmarBenSalem

The Months that are not shown are not ASSOCIATED with you selection; not they are and contains 0 values but they're not associated with ur selection; that's why they're GREY in the filter pane and thus are not shown in the bar

Digvijay_Singh

Looks like it is showing values for selected filters only. Did you try checking show zero values in properties(add-on)?

Or normally this works to show all dimension values -

What does it mean sum({1} 0)?

Anonymous
Not applicable
Author

Thanks for reply but Months; 2017-08 and 2017-09 and 2018-01 are also not associated but Qlik fills zero values as you see bar and table chart.

Anonymous
Not applicable
Author

Yes, its checked.

sasiparupudi1
Master III
Master III

Please attach a sample

jitenderkalouni
Contributor II
Contributor II

any solution for this ?