Remove Hyphen in Bar Chart for Null Values

[Anonymous]

Hi,

I have a bar chart which is supposed to show null values count as well and it gets displayed correctly. The problem is that the label for the null values is Hyphen "-".

How can I replace the hyphen with a custom text, say "Unassigned"?

Thanks,

Sandeep

[sunny_talwar]

May be like this

Dimension

If(Len(Trim(Sector)) = 0, 'Unassigned', Sector)

[NZFei]

Fix it in the script, otherwise you have to modify the dimension for each single object.

[shraddha_g]

uncheck Show Null Values in Dimension Section

[Anonymous]

Hi Sunny,

I have tried it and it is not working. Below is a screenshot.

Thanks,

Sandeep

[sunny_talwar]

How about this

If(Sector = '-', 'Unassigned', Sector)

[Anonymous]

Hi Fei,

Can you share a link which explains how to do this in a script? I have just started off development on QlikSense and dont know too much about the various features.

Thanks,

Sandeep

[Anonymous]

Hi Shraddha,

We need the null values to be shows in the bar chart. So, this is not an option.

Thanks,

Sandeep

[Anonymous]

Hello,

Try this for your dimension:

If(isnull(Sector),'Unassigned', Sector)

[Anonymous]

That also does not work.