Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
AnnaQlik
Partner - Contributor II
Partner - Contributor II

Change Null-symbol in bar chart

Hi,

In a Pivot table you can change the Null-symbol in chart properties -> presentation.

Is it possible to change the Null-symbol in a bar chart as well?

Thanks!

Labels (3)
1 Solution

Accepted Solutions
zhadrakas
Specialist II
Specialist II

i dont think that you will find this funcion there.
You could edit your Expression to convert NULL and Blank Values to 0 or whatever you want to Show.

like:
if(len(trim(FIELD))=0, 0, FIELD)

regards
tim

View solution in original post

3 Replies
Anil_Babu_Samineni

Can you show image what currently it is showing? and what you are expecting?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
zhadrakas
Specialist II
Specialist II

i dont think that you will find this funcion there.
You could edit your Expression to convert NULL and Blank Values to 0 or whatever you want to Show.

like:
if(len(trim(FIELD))=0, 0, FIELD)

regards
tim
AnnaQlik
Partner - Contributor II
Partner - Contributor II
Author

Thank you Zhadrakas!!