handling null values

[Anonymous]

Hi,

As in screen shot I have data like this after I made some calculations. But what my requirement is in between 02/13/2015 and 02/21/2015 dates have been missed. I want to display '0' where dates have been missed.

like this i want to display.

02/13/2015  106,237  

02/14/2015    0

02/15/2015     0

02/16/2015     0

02/17/2015     0

02/18/2015

02/19/2015

.

.

02/21/2015    40.195

Pls help me on this.

Thanks

[Anonymous]

I did it, but no use. Actually this date field is time stamp.

[sasiparupudi1]

in the script,

load Date,

if (len(Value)=0,0,Value) as Value

load  inline

[

Date  Value

02/13/2015  106,237  

02/14/2015    0

02/15/2015     0

02/16/2015     0

02/17/2015     0

02/18/2015

02/19/2015

.

.

02/21/2015    40.195

];

in your straighttable uncheck supress zero values option

hth

Sasi

[qlikviewwizard]

‌hi Kiran,

can you attach sample file to demonstrate your issue? Thank you

[Anonymous]

it is an incremental load. Everything will get from database. We should not use inline load here.

[Anonymous]

Deepak, I incorporated the same.

See the screen shot. there is no at the end it is adding '0' after made it as ascending order.

[Anonymous]

All files are available in remote desk top. I can't copy into my local machine

[sasiparupudi1]

Hi

the inline load I have given as an example only. You could use the

condition if (len(Value)=0,0,Value) as Value

in your load script for null values

hth

Sasi

[qlikviewwizard]

Hi Kumar,

Pls check the attachment. Hope this will help you.

[Anonymous]

Hi,

In ur example still dimensions are missing, but in my date dimension the dates are there. To the corresponding date i don't have any value in expressions. Like this some of values are missing in expressions.

In above table the highlighted with yellow dates have been missed. because there is count and sum to the corresponding dates. Like 2 table it should be populate missing dates where null value is there along with it will be display 0 in place of null.

Regards,

kumar

[qlikviewwizard]

Hi kumarreddy257

Please provide the sample data with qvw to demonstrate your requirement. It will help the folks in easy understand.

Thank you.