0 Replies Latest reply: Jan 6, 2010 10:50 PM by msmitheman RSS

    Working with dates

    msmitheman

      I am new to Qlikview so looking for some "best practice" approaches around date handling.

      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.

      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.

      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.

      So a simple example might be:

      a table in the database has employee history information. One of the columns is employment date.

      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)?

      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?

      Thanks for any advice