Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this
Dimension
If(Len(Trim(Sector)) = 0, 'Unassigned', Sector)
Fix it in the script, otherwise you have to modify the dimension for each single object.
uncheck Show Null Values in Dimension Section
Hi Sunny,
I have tried it and it is not working. Below is a screenshot.
Thanks,
Sandeep
How about this
If(Sector = '-', 'Unassigned', Sector)
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
Hi Shraddha,
We need the null values to be shows in the bar chart. So, this is not an option.
Thanks,
Sandeep
Hello,
Try this for your dimension:
If(isnull(Sector),'Unassigned', Sector)
That also does not work.