Display missing bars in a bar chart

[manideep78]

Dear Community,

I wanted to show the bar chart with 2 dimensions like a below image:

But here, for the first dimension some values are missing in second dimension (marked in the red circle) and it show empty with out even showing a zero value.

can you please suggest me know how can I display the missing second dimension with 0 value.

any help would be appreciated.

Thanks in advance.

Regards,

Manideep

[sunny_talwar]

Try checking Zeros on bar on the presentation tab. Also make sure that Suppress Zero Values is unchecked

[manideep78]

Hi Sunny,

Thanks for the quick reply. I tried every possible option but no luck.

Regards,

Manideep

[sunny_talwar]

How about if you add + Avg({1} 0) to your expression? and then follow the above directions?

[manideep78]

Still the issue remains same Sunny.

Regards,

Manideep

[sunny_talwar]

Would you be able to share a sample?

[manideep78]

Hi Sunny, here is my sample app. !

[sunny_talwar]

I guess the issue is that the dimension is not just null, but it is missing. I think, you will need to add those missing dimensions back in order to make this to work.

[thakkarrahul01]

Hi Manideep,

Along with what stalwar1‌ Sunny T suggested can you try modifying expression as in QlikSense Dimension: show all values like QlikView?

[manideep78]

Yes, It is not null, but it is missing.