Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Partner
Partner

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
Valued Contributor

Re: Change Null-symbol in bar chart

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
3 Replies

Re: Change Null-symbol in bar chart

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
zhadrakas
Valued Contributor

Re: Change Null-symbol in bar chart

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
Partner
Partner

Re: Change Null-symbol in bar chart

Thank you Zhadrakas!!