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?

[swuehl]

How does you expression look like, how does your data (model) look like, what's the context of your expression?

[carolinne88]

Hi, Stefan.

My expression is: =Count( {< $(vMesRef) >} [natureza jurídica]) 

vMesRef --> PerID = {$(=Max(PerID))} (PerID is a autonumber).

[swuehl]

So

=Max(PerID)

in a text box does not bring back the requested month ID?

Or how are the PerID and [natureza jurídica]  fields related in your data model, where do you see the NULL?

Could you post some sample records?

[carolinne88]

Max (PerID) returns yes the last month. The problem is that in the data table that I do not appear the field information without occurrence of values.

Example:
Sales in the month of October / 17:
Salesman
A 100
C 45
D 60

As seller B did not make sales in the month of October / 17, it does not appear in the table.

[swuehl]

So what's the contex of your expression? A table chart with dimension Seller? And any active selections?

Are you talking about seeing the september sales for seller B in your sample instead of october sales, as seen for seller A.C.D?

[swuehl]

If possible, please create and upload a small sample application, I think this will be more efficient to clarify your issue.

[andrei_delta]

Hello,

From what i understand you have null values in the Salesman field and you want the null values to be changed to 0.

you can do that in script with alt(Salesman,0) as Salesman

Hope it helps,

Andrei

[techvarun]

If(IsNull(YourField),0,YourField) as YourField

try the above script while loading the data

[avinashelite · Accepted solution]

As per my understanding your facing missing data problem , en order for the sales man B to appear for Oct then you need to have the value first ...follow this thread you will get the answer

Fill in missing dates till today

Generating Missing Data In QlikView