Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

meizheng
New Contributor III

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
Valued Contributor

Re: Show all values in bar chart regardless of selection and nulls

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?

meizheng
New Contributor III

Re: Show all values in bar chart regardless of selection and nulls

Hi Luis,

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

Community Browser