Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Through Put Yield

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

4 Replies
MVP
MVP

Re: Through Put Yield

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

Not applicable

Re: Through Put Yield

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


apache_rai
New Contributor III

Re: Through Put Yield

Share some sample data or more detail of your dashboard.

Not applicable

Re: Through Put Yield

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%
Community Browser