Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
panwipa2528
Contributor III
Contributor III

How to full fill zero on the chart?

Need to full fill zero as sample

Need like this

1 Solution

Accepted Solutions
techvarun
Specialist II
Specialist II

Checksample.PNG the attached

View solution in original post

12 Replies
mayankraoka
Specialist
Specialist

Hi,

Another way is to do it on pivot table attached screenshot for reference:

Regards,

Mayank

panwipa2528
Contributor III
Contributor III
Author

My customer need to present in chart.

mayankraoka
Specialist
Specialist

For that you need to create rows with null values for every non-existing combination of the key.Then the sum on null should work and return 0 .For this just check show all values for dimensions.

Regards,

Mayank

panwipa2528
Contributor III
Contributor III
Author

already check but it not work.

kavita25
Partner - Specialist
Partner - Specialist

What are your dimensions as per the excel?

Sergey_Shuklin
Specialist
Specialist

Hello!

Check "Show Zero Values" on Presentation tab. Should work.

kavita25
Partner - Specialist
Partner - Specialist

Unchecked Suppress Zero-Values, Suppress Missing.. under presentation tab.

And checked Zero on Bars...

panwipa2528
Contributor III
Contributor III
Author

Not working

kavita25
Partner - Specialist
Partner - Specialist

uncheck suppress missing