Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AlexPanda5
Partner - Contributor
Partner - Contributor

QlikSense set values to 0

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!

2 Replies
MadiF
Contributor III
Contributor III

@AlexPanda5Hello! Have you tried wrapping your fields in this condition, either in the front end or the load script:

if(isnull(FieldName), '0', FieldName)

Or
MVP
MVP

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 '-'.