Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Replace Null, Dash Value with zero through script

Hi,

In attached QVW, I want to replace null, '-' Value with 0 (Numeric Zero). By Script level or Expression level, not from layout level (like Suppress Null Value in Dimension and Presentation level - Set - value as 0).

Please have a look and do the needful.

Regards,

QV TEAM

Labels (1)
3 Replies
jwjackso
Specialist III
Specialist III

Look at the NullDisplay and NullValue  settings.  The best option is to control the nulls in the original datasource.

sona_sa
Creator II
Creator II
Author

I tried all the way from all script level. But able to get the proper solution. 😞

Regards,

QV TEAM

sona_sa
Creator II
Creator II
Author

Dear Team,

I tried all the way from all script level. But not able to get the proper solution.  Just I want zero (0), intead of  dash (-), but script level.😞

I tried trim, isnull, len, set variable, by using nullvalue etc.

Regards,

QV TEAM