topic Fill in extra dates in QlikView

Fill in extra dates

sjhussain — Wed, 04 May 2016 19:03:01 GMT

‌Hello

Hope everyone is fine.

We have a GL table and would like to fill in the dates with 0 amount. The table has the following example information.

There will be a lot of missing data for the date which we want to fill.

CompanyName, BusinessLine, ACCTID,Date,Amount

abc,bl1,revenue,jan-2016,45000

abc,bl1,revenue,mar-2016,90000

abc,bl1,revenue,may-2016,10000

what we want to do is to insert

abc,bl1,revenue,feb-2016,0 And

abc,bl1,revenue,apr-2016,0

hope someone can assist us.

thanks

sunny_talwar — Wed, 04 May 2016 19:05:04 GMT

You need to add Master Calendar to your application and then you will have those extra dates available in your application

Nicole-Smith — Wed, 04 May 2016 19:07:36 GMT