topic Re: Change Null-symbol in bar chart in QlikView

Change Null-symbol in bar chart

AnnaQlik — Sat, 16 Nov 2024 03:46:37 GMT

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!

Re: Change Null-symbol in bar chart

Anil_Babu_Samineni — Wed, 24 Apr 2019 09:41:45 GMT

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

Re: Change Null-symbol in bar chart

zhadrakas — Wed, 24 Apr 2019 09:44:04 GMT

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

Re: Change Null-symbol in bar chart

AnnaQlik — Wed, 24 Apr 2019 09:48:29 GMT

Thank you Zhadrakas!!