Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table Data Load Incorrect

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.

4 Replies
m_woolf
Master II
Master II

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

Not applicable
Author

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
Champion III
Champion III

Chanty4u
Champion III
Champion III