Need advice on global date approach

Tue, 03 Mar 2015 04:25:16 GMT

Manish answered a renewal rate question for me that has helped me understand broader issue with my data set, and visualizations I need to provide. Below is an example of my data set. As you can see I have many dates. I need to be able to show count of contracts under a given date scenario(s) for a given period of time. For example, I need the ability to display a line chart where my dimension or x-axis is a given time period (days of a week, weeks of month, etc...--not one of the dates listed below), and my expressions are number of contracts with an Acct_Date, Eff_Date, Exp_Date and/or any other date below, equal to that period (day/wk/mo). It seems I need to introduce some sort of global date, but I am not sure of the best way to do this. Number of contracts is 7-10 million over multi-year span and all contracts have all of the respective dates.

Thanks for any direction you can provide.

Gary

Contract_ID,

State,

Price,

List_Date,

List_Exp_Date,

Acct_Date,

Pymt_Method,

Pay_Plan,

Closepay_Date,

Entry_Date,

Eff_Date,

Exp_Date,

Cancel_Date,

Channel,

Source,

Re: Need advice on global date approach

tresB — Tue, 03 Mar 2015 04:34:02 GMT

Check this blog: Canonical Dates

Re: Need advice on global date approach

Tue, 03 Mar 2015 17:34:05 GMT

This is exactly what I need. Whether I can execute or not may be a different story. Thank you for the direction. Gary

topic Need advice on global date approach in QlikView

Need advice on global date approach

Re: Need advice on global date approach

Re: Need advice on global date approach