topic Re: Replace Null, Dash Value with zero through script in QlikView

Replace Null, Dash Value with zero through script

sona_sa — Sat, 16 Nov 2024 00:35:22 GMT

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

Re: Replace Null, Dash Value with zero through script

jwjackso — Thu, 28 May 2020 15:43:13 GMT

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

Re: Replace Null, Dash Value with zero through script

sona_sa — Thu, 28 May 2020 16:09:17 GMT

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

Regards,

QV TEAM

Re: Replace Null, Dash Value with zero through script

sona_sa — Thu, 28 May 2020 20:05:59 GMT

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