Discussion board where members can get started with Qlik Sense.
My question is rather simple.
Is there a way to change the custom message in the pie chart in case there is null values?
What I would prefer is to have a pie chart with a single color and value as 0; but if that is not possible; I want to be able to change the message.
Is this possible? and if so, how should I proceed?
Go to the properties of the chart.
in General Tab>Click on the Option of error Messages.>calculated condition unfulfilled..> there u can write a custom Message.
In order to show 0 when no values , use alt() function on your expression and make sure you show zero values on the Presentation tab
Am not sure but you can try
or else you can try in general tab below you will find error message option check that also.
Where can I find this?
Besides, how should I use alt() function in this case , here is what I'm trying to do :
Thank you Chanty but I'm searching for a solution in qlik sense
yeah sorry i didn't checked there is no option in qliksense Afaik .. but you can check for any extension in Qlikbranch
I'm sorry, after double checking this option is no longer available.
the alt function can be used like this:
hope it helps