Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

Look here: Canonical Date