Posting Date issue

[#1]

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??

[MK_QSL]

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

[lukaspuschner]

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