Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
thomas_skariah
Creator III
Creator III

Populating 0 value in missing month

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

2 Replies
sivarajs
Specialist II
Specialist II

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.