Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
0li5a3a
Creator III
Creator III

Nulls in Pivot Table and Bart Chart

Hi all,

Could someone adivce me how to DON'T display the  " -" into the Pivot Table and Bart Chart?

I want to mention that I still want to display the Months with no data in it but I don't want to see this " - " in the legend in the Bart Chart and in Type in the Pivot Table.

Please find the attached files where I have created a scenario.

Kind regards,

C

Capture.PNG

1 Solution

Accepted Solutions
0li5a3a
Creator III
Creator III
Author

Hi all,

I come with the solution, please use it in future if you need to exclude the nulls from legends.

Regards, C

Capture.PNG

View solution in original post

16 Replies
Chanty4u
MVP
MVP

in dimension

check supres null value .

in presentation tab also do the same

dapostolopoylos
Creator III
Creator III

Capture.JPG

Father/Husband/BI Developer
0li5a3a
Creator III
Creator III
Author

Hi ,

If you do this you would not be able to see Sep, Nov and Dec and I want to be able to see it.

Regards,Capture.PNG

0li5a3a
Creator III
Creator III
Author

This is not right, I want to see Sep, Oct, Nov and Dec in my charts.

Capture.PNG

0li5a3a
Creator III
Creator III
Author

Any guru expers?

dapostolopoylos
Creator III
Creator III

Have you tried to play with the "Show All Values" checkbox?

Father/Husband/BI Developer
0li5a3a
Creator III
Creator III
Author

Yes, but stii the same:)

sergio0592
Specialist III
Specialist III

Hi, in pivot chart you can manage Missing value/Nul symbol and remove -

Nul_value.jpg

0li5a3a
Creator III
Creator III
Author

thnaks for that but still not done,

Capture.PNG