topic Re: Through Put Yield in QlikView https://community.qlik.com/t5/QlikView/Through-Put-Yield/m-p/1026363#M466507 <HTML><HEAD></HEAD><BODY><P>So, I do funnel data analysis so for example:</P><P></P><P>Lead 1 comes in Jan 2016</P><P>Loan is funded April 2016</P><P></P><P>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. </P><P></P><P><SPAN style="font-size: 13.3333px;">Lead 1 comes in Jan 2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">Lead 2 comes in Jan 2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">Lead 3 comes in Jan 2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">Lead 4 comes in Jan 2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">Loan is funded April 2016</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">So the TPY is 25% (1 funded/4 leads). <BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Tue, 02 Feb 2016 18:17:36 GMT 2016-02-02T18:17:36Z Through Put Yield https://community.qlik.com/t5/QlikView/Through-Put-Yield/m-p/1026361#M466505 <HTML><HEAD></HEAD><BODY><P>Creating some dashboard but finding some difficulty in creating a TPY for my analysis. Any advice?</P></BODY></HTML> Mon, 01 Feb 2016 23:47:29 GMT https://community.qlik.com/t5/QlikView/Through-Put-Yield/m-p/1026361#M466505 2016-02-01T23:47:29Z Re: Through Put Yield https://community.qlik.com/t5/QlikView/Through-Put-Yield/m-p/1026362#M466506 <HTML><HEAD></HEAD><BODY><P>Try to share a bit more about your requirement. Check: <A href="https://community.qlik.com/docs/DOC-2380">QlikCommunity Tip: How to get answers to your post?</A></P></BODY></HTML> Tue, 02 Feb 2016 06:10:31 GMT https://community.qlik.com/t5/QlikView/Through-Put-Yield/m-p/1026362#M466506 tresB 2016-02-02T06:10:31Z Re: Through Put Yield https://community.qlik.com/t5/QlikView/Through-Put-Yield/m-p/1026363#M466507 <HTML><HEAD></HEAD><BODY><P>So, I do funnel data analysis so for example:</P><P></P><P>Lead 1 comes in Jan 2016</P><P>Loan is funded April 2016</P><P></P><P>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. </P><P></P><P><SPAN style="font-size: 13.3333px;">Lead 1 comes in Jan 2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">Lead 2 comes in Jan 2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">Lead 3 comes in Jan 2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">Lead 4 comes in Jan 2016</SPAN></P><P><SPAN style="font-size: 13.3333px;">Loan is funded April 2016</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">So the TPY is 25% (1 funded/4 leads). <BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Tue, 02 Feb 2016 18:17:36 GMT https://community.qlik.com/t5/QlikView/Through-Put-Yield/m-p/1026363#M466507 2016-02-02T18:17:36Z Re: Through Put Yield https://community.qlik.com/t5/QlikView/Through-Put-Yield/m-p/1026364#M466508 <HTML><HEAD></HEAD><BODY><P>Share some sample data or more detail of your dashboard.</P></BODY></HTML> Tue, 02 Feb 2016 18:28:25 GMT https://community.qlik.com/t5/QlikView/Through-Put-Yield/m-p/1026364#M466508 ajayrai 2016-02-02T18:28:25Z Re: Through Put Yield https://community.qlik.com/t5/QlikView/Through-Put-Yield/m-p/1026365#M466509 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="415"><TBODY><TR><TD height="20" width="64">Name</TD><TD width="88">Lead Date</TD><TD width="89">Funding Date</TD><TD width="76">Lead Count</TD><TD width="98">Funding Count</TD></TR><TR><TD height="20">Test 1</TD><TD align="right" class="xl63">1/1/2016</TD><TD align="right" class="xl63">4/1/2016</TD><TD align="right">1</TD><TD align="right">1</TD></TR><TR><TD height="20">Test 2</TD><TD align="right" class="xl63">1/5/2016</TD><TD align="right">1</TD><TD align="right">0</TD></TR><TR><TD height="20">Test 3</TD><TD align="right" class="xl63">1/11/2016</TD><TD align="right">1</TD><TD align="right">0</TD></TR><TR><TD height="20">Test 4</TD><TD align="right" class="xl63">1/19/2016</TD><TD align="right">1</TD><TD align="right">0</TD></TR><TR><TD>Total Lead</TD><TD align="right">4</TD></TR><TR><TD>Total Funded</TD><TD align="right">1</TD></TR><TR><TD>TPY</TD><TD align="right" class="xl64">25%</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 02 Feb 2016 23:29:58 GMT https://community.qlik.com/t5/QlikView/Through-Put-Yield/m-p/1026365#M466509 2016-02-02T23:29:58Z