Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-02-01 06:47 PM

Through Put Yield

Creating some dashboard but finding some difficulty in creating a TPY for my analysis. Any advice?

278 Views
0 Likes
4 Replies
tresesco
MVP
MVP
‎2016-02-02 01:10 AM

Try to share a bit more about your requirement. Check: QlikCommunity Tip: How to get answers to your post?

187 Views
0 Likes
Not applicable
‎2016-02-02 01:17 PM
Author

In response to tresesco

So, I do funnel data analysis so for example:

Lead 1 comes in Jan 2016

Loan is funded April 2016

I would like to match that funded loan back to that lead that came in Jan 2016 and do a TPY, which is loan funded/Lead count.

Lead 1 comes in Jan 2016

Lead 2 comes in Jan 2016

Lead 3 comes in Jan 2016

Lead 4 comes in Jan 2016

Loan is funded April 2016


So the TPY is 25% (1 funded/4 leads).


187 Views
0 Likes
ajayrai
Partner - Contributor III
Partner - Contributor III
‎2016-02-02 01:28 PM

Share some sample data or more detail of your dashboard.

187 Views
0 Likes
Not applicable
‎2016-02-02 06:29 PM
Author

In response to ajayrai
NameLead DateFunding DateLead CountFunding Count
Test 11/1/20164/1/201611
Test 21/5/201610
Test 31/11/201610
Test 41/19/201610
Total Lead4
Total Funded1
TPY25%
187 Views
0 Likes