topic Re: QlikView Script remove missing value to zero in QlikView

QlikView Script remove missing value to zero

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

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

Re: QlikView Script remove missing value to zero

tresB — Fri, 29 May 2020 10:26:31 GMT

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.

Re: QlikView Script remove missing value to zero

sona_sa — Fri, 29 May 2020 12:34:29 GMT

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.

Re: QlikView Script remove missing value to zero

tresB — Fri, 29 May 2020 14:18:33 GMT

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

Re: QlikView Script remove missing value to zero

sona_sa — Fri, 29 May 2020 15:24:40 GMT

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,