Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

2 Dates in 1 Chart

I am looking to work out Take Up Rate Which is Number of Policies/ Number of Quotes.

However the data is stored in 2 tables and joined via QuoteID.

For Quotes we will use the QuoteDate to Measure how many we have quoted and for Policies we will use the Policy Date to measure how many policies we have on cover.

However i want to create a chart which combines these dates so that i am able to see that for the Quote Date of Jan and Policy Date of Jan we have taken up x%.

Below is an example of how our data would look and the expected take up rates.

Jan 16 Take Up - 66%

Feb 16 Table Up - 75%

QuoteIDQuoteDatePolicyIDPolicyDate
101/01/2016101/01/2016
201/01/2016--
301/01/2016201/01/2016
401/02/2016301/02/2016
501/02/2016401/02/2016
601/02/2016501/02/2016
701/02/2016--

Any assistance on how to "merge" these 2 dates into 1 would be greatly appreciated.

Natalie

1 Reply

Re: 2 Dates in 1 Chart

Look here: Canonical Date

Community Browser