topic Re: Posting Date issue in QlikView

Posting Date issue

Wed, 24 Dec 2014 10:08:18 GMT

Every material code is having different max(posting date) . and in that posting date many posting date are missing in between for e.g after 01/08/2014 , there is a entry for 03/08/2014 .. so the 02/08/2014 data is missing ... now i want to add that 02/08/2014 in posting that . can anyone help ... how to do that??

Re: Posting Date issue

MK_QSL — Wed, 24 Dec 2014 10:10:14 GMT

Create a master calendar.. or upload your sample data.

You can create the same using Loop in your script..

or use below link

Generating Missing Data In QlikView

Re: Posting Date issue

lukaspuschner — Wed, 24 Dec 2014 10:23:43 GMT

Hi,

this will solve your problem.

if(IsNull(YourDateField),date(Previous(YourDateField)+1),YourDateField) as YourDateField

Maby there is a abetter way without if but for the moment this will help you.

Lukas