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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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