Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amuratbar
New Contributor III

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

Tags (2)
6 Replies
OmarBenSalem
Esteemed Contributor

Re: Show all zero values

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
Honored Contributor III

Re: Show all zero values

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)?

amuratbar
New Contributor III

Re: Show all zero values

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.

amuratbar
New Contributor III

Re: Show all zero values

Yes, its checked.

sasiparupudi1
Honored Contributor III

Re: Show all zero values

Please attach a sample

jitenderkalouni
New Contributor II

Re: Show all zero values

any solution for this ?

Community Browser