Zero for null fields

[carolinne88]

Hello guys! I need help.

I have a data worksheet that does not notify zero for null values.

When I put in the expression to bring in the value of the last month, it returns the value of the preceding month.

I need zero to appear.

Can anyone help?

[HirisH_V7]

Better Specify the Field that contains nulls or empty as you said, As '0' and load it again.

Use Script as Varun suggested for that field in Script Side.

[carolinne88]

Thanks for the suggestions and I'll check back soon. I'll give you a return. Thank you!

[Anonymous]

try this:

Alt(PerID,0)

[carolinne88]

Guys, I still have the same problem.

When I put the expression to return the value of the last PerID, as there is no data from the "B seller", it returns the data from the last month that there was sales of B. It does not return zero as I would like.

[techvarun]

A sample qvw or data would help the community to help you better

[carolinne88]

Hi guys!

Thanks to Varun's advice, I was able to solve my problem. I found this link here in other forum discussions.

Link: https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field

Thank you all!

[carolinne88]

by Avinash's tips *

sorry.