Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
carolinne88
Creator
Creator

Zero for null fields

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?

1 Solution

Accepted Solutions
avinashelite

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

View solution in original post

16 Replies
swuehl
MVP
MVP

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

carolinne88
Creator
Creator
Author

Hi, Stefan.

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

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

swuehl
MVP
MVP

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
Creator
Creator
Author

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
MVP
MVP

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
MVP
MVP

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

andrei_delta
Partner - Creator III
Partner - Creator III

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
Specialist II
Specialist II

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

try the above script while loading the data

avinashelite

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