Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ziabobaz
Creator III
Creator III

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

1 Reply
Lisa_P
Employee
Employee

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.