Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ziabobaz
Contributor II

Bar chart showing null values (need global solution)

That's what I have

Screenshot_101.jpg

What i need:

Screenshot_102.jpg

I am using local solution, adding "+ SUM({1}0)" to a Chart formula, but is there a global solution? Otherwise I would have to redo each master formula in my project, which I don't want to do.

Thank you

Tags (3)
1 Reply
Employee
Employee

Re: Bar chart showing null values (need global solution)

This is because the other dimensions don't exist in the data.  An easy way would be to add them in.  I can't understand your data (language), but if you are looking at months, then add a new table that just has 12 months and associate it with the data, this will then help you fill the gaps.  You could also look at creating a master calendar, there are lots of threads on this topic.

Community Browser