Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Show all values in bar chart regardless of selection and nulls

Hi,

I have the following bar chart and I currently am able to show all Overdue (Months) fields even if the selected month (Eg. Jan 2018) has nulls for that Overdue field (only < 3 Months values exist). I also want to show all 7 departments as seen in the '< 3 Months' section. There should be 7 zeroes for the other Overdue (Months) fields. How can I achieve this?

Dimensions: Overdue (Months; Total 5) and Department (Total 7)

My current measure is:

if(Count({1} [Department]) > 0,

Count({$<[VA.Month]={'$(=Max([VA.Month]))'}>}

     distinct ([%ItemID])),

    0)

ageing-barchart.PNG

Thanks!

Serena

2 Replies
luismadriz
Specialist
Specialist

Hi,

Do you want to fix that chart to always show 28 bars (7 departments in 4 groups) regardless of having nulls? and nulls showing as zeros, I suppose?

Anonymous
Not applicable
Author

Hi Luis,

Yes, I want to show 35 bars (7 departments in 5 groups) regardless! Nulls should be shown as zeroes