QlikView Script remove missing value to zero

[sona_sa]

Hi Team,

I have trying to replace missing value to zero (0) in my Pivot table through expression and script. But not able to replace.

I tried all logic - like - isnull, nullasnull, nullasvalue, alt, len etc. But not success.

Please help me on this. Please look into it, I am attaching the qvw. Please look into it.

Regards,

QV Team

[tresesco]

It appears that these values in table are actually missing value and not really nulls. And these don't come from data but created while the pivot table structure is generated. You can replace these missing values by zeros in presentation tab -> Missing Symbol.

[sona_sa]

Hi Team,

As I mentioned, I need to do it in Script or expression. By Properties level yes we know, we can do it.

Need do make the possible output through script level or expression level. We can not do anything for this from script level.

Thanks for response.

[tresesco]

Have a look at : https://community.qlik.com/t5/Qlik-Design-Blog/How-to-populate-a-sparsely-populated-field/ba-p/14706...

[sona_sa]

Hi Tresesco,

I tried the script, But due to more number of records and dimensions, It is giving Cartesian value, and duplicates records. I understand for less no. of dimension value and records, It will work. 

Any another way by scripts.

I am trying also. Can u check by your side.

Regards,

SA