Populating 0 value in missing month

[thomas_skariah]

Hi All,

Can anyone suggest how to populate 0 value in missing month and can be done in back end scripting side?

Pls find attach sample application.

Regards,

Tom

[tresesco]

Have a look here: http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field

[sivarajs]

Not sure you have formatted data. But logic in script creates missing values for your dimension. Then use sum(value)+0.0001, will show some values for your missing dimension. Later change number format to integer it will round off to zero.