Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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 II
Specialist II

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