Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have this table in QlikSense. Is possible to make the '-' values look like '0' or 'Not'? That values are appearing like that because them don't exist in the previous model (QlikView). I've been trying to add them in that mdoel but is not so simple,
Thank you!
@AlexPanda5Hello! Have you tried wrapping your fields in this condition, either in the front end or the load script:
if(isnull(FieldName), '0', FieldName)
?
Depending on how the null value is arrived at, you may be able to get around this using the method suggested by @MadiF or by using NullAsValue as detailed here: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip... or the NullDisplay option https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/assoc...
However, if the null is arrived at through a missing intersection in the pivot table, I'm not sure if either of these will solve your problem. If not, note that some third-party pivot tables allow you to set your own null indicator rather than the default '-'.