Pivot Table Data Load Incorrect

[#1]

i am facing a challenge in pivot table, when i am trying to load the data from DB with filter conditions few dates are not getting picked and plotted in pivot as they are getting filtered, hence the dates are getting jumped in pivot table but i want all dates to be pivot table and corresponding dates should show zero in the fields below is the screenshot of current status in pivot table.

[m_woolf]

You can either use a master calendar or fill in the missing dates in your load script.

[#3]

hi,

can you please share master calendar script please and let me know if any configurations has to be done in Qlikview front end.

thanks in advance.

[Chanty4u]

chk dis

Creating A Master Calendar

[Chanty4u]

or dis

The Master Calendar