topic Working with dates in QlikView https://community.qlik.com/t5/QlikView/Working-with-dates/m-p/178910#M1310967 <HTML><HEAD></HEAD><BODY><P>I am new to Qlikview so looking for some "best practice" approaches around date handling.</P><P>I have a single database that is a dump of our operational data with very little data modeling going on. We do not have a date table within there.</P><P>I would like to bring in operational data and associate it with dates and I'm wondering whether it would be best to maintain a date table within the database or whether I could handle it in Qlikview effectively.</P><P>I can see how I can easily create a calendar dimension in Qlikview and map data that has a date stamp on it, but a lot of my data has what I would call effective dates.</P><P>So a simple example might be:</P><P>a table in the database has employee history information. One of the columns is employment date.</P><P>What if I wanted to show a monthly trend over a number of years, showing how many employees were employed for the selected month (effectively a headcount at that point in time)?</P><P>One way would be to manage it in the database, but if I created a calendar "dimension" in Qlikview directly is there an effective way to map my data to it?</P><P>Thanks for any advice</P><P></P><P></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT 2026-01-26T18:19:17Z Working with dates https://community.qlik.com/t5/QlikView/Working-with-dates/m-p/178910#M1310967 <HTML><HEAD></HEAD><BODY><P>I am new to Qlikview so looking for some "best practice" approaches around date handling.</P><P>I have a single database that is a dump of our operational data with very little data modeling going on. We do not have a date table within there.</P><P>I would like to bring in operational data and associate it with dates and I'm wondering whether it would be best to maintain a date table within the database or whether I could handle it in Qlikview effectively.</P><P>I can see how I can easily create a calendar dimension in Qlikview and map data that has a date stamp on it, but a lot of my data has what I would call effective dates.</P><P>So a simple example might be:</P><P>a table in the database has employee history information. One of the columns is employment date.</P><P>What if I wanted to show a monthly trend over a number of years, showing how many employees were employed for the selected month (effectively a headcount at that point in time)?</P><P>One way would be to manage it in the database, but if I created a calendar "dimension" in Qlikview directly is there an effective way to map my data to it?</P><P>Thanks for any advice</P><P></P><P></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Working-with-dates/m-p/178910#M1310967 2026-01-26T18:19:17Z