Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Display missing values in calender

Hi

Could any body please let me know how do i display the missing dates for a time_stamp value,

for eg i have a datetime field time_stamp , i have data from 01/10/2011 - 01/15/2011, the data for 01/11/2011 is missing , so when i crate a graph showing trend from date(time_stamp) values i dont see date 01/11/2011, i guess this because there is no data for that day , how do i display 01/11/2011 also on the x -axis

Thanks

1 Reply
Anonymous
Not applicable
Author

Create a calendar in a separate logical table. See an example here:
http://community.qlik.com/wikis/qlikview-wiki/how-to-create-a-calendar.aspx