topic Index/Match formula in QlikView in QlikView https://community.qlik.com/t5/QlikView/Index-Match-formula-in-QlikView/m-p/1092759#M363293 <HTML><HEAD></HEAD><BODY><P>Hello all</P><P></P><P>How do i perform Index/Match formula in QlikView. Please see below to get an idea of what I'm trying to do:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 625px;"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt;">Ratio</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">1st</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">2nd</SPAN><SPAN style="font-size: 9.0pt; color: red;">*</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">3rd</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">4th</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: none; border-left: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt; color: black;">QUARTILE VALUES</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;"> 0.12 </SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.25 </SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #4F81BD; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><STRONG style="color: white; font-size: 9.0pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.43 </STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.00 </SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: none; border-left: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt; color: black;">NO. OF BORROWERS</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;"> 178 </SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 175 </SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 174 </SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 175 </SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt;">Borrower Name</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P><SPAN style="font-size: 9.0pt;">Borrower's Ratio</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P><SPAN style="font-size: 9.0pt;">Borrower's Quartile</SPAN></P></TD><TD></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt;">XXXXXXXXXXXXXX</SPAN></P></TD><TD nowrap="nowrap" style="border-style: none solid solid none; border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; padding: 0px 5.4pt; text-align: right; background: rgb(79, 129, 189);" valign="bottom" width="71"><P><STRONG style="color: white; font-size: 9.0pt;">0.38</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt;">3rd</SPAN></P></TD><TD></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt; color: red;">*</SPAN><SPAN style="font-size: 9.0pt; color: black;"> Limit of 2nd quartile is 0.25. Hence, borrower's ratio of 0.38 will be parked under 3rd quartile.</SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>All objects above are recursively calculated depending on what the user selects.</P><P></P><P>Thanks,</P><P>Jeffry</P></BODY></HTML> Thu, 17 Mar 2016 03:58:32 GMT 2016-03-17T03:58:32Z Index/Match formula in QlikView https://community.qlik.com/t5/QlikView/Index-Match-formula-in-QlikView/m-p/1092759#M363293 <HTML><HEAD></HEAD><BODY><P>Hello all</P><P></P><P>How do i perform Index/Match formula in QlikView. Please see below to get an idea of what I'm trying to do:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 625px;"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt;">Ratio</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">1st</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">2nd</SPAN><SPAN style="font-size: 9.0pt; color: red;">*</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">3rd</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">4th</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: none; border-left: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt; color: black;">QUARTILE VALUES</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;"> 0.12 </SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.25 </SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #4F81BD; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><STRONG style="color: white; font-size: 9.0pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.43 </STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.00 </SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: none; border-left: solid windowtext 1.0pt; border-bottom: solid windowtext 1.0pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt; color: black;">NO. OF BORROWERS</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;"> 178 </SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 175 </SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 174 </SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 175 </SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="68"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt;">Borrower Name</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P><SPAN style="font-size: 9.0pt;">Borrower's Ratio</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P><SPAN style="font-size: 9.0pt;">Borrower's Quartile</SPAN></P></TD><TD></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #EBF1DE; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt;">XXXXXXXXXXXXXX</SPAN></P></TD><TD nowrap="nowrap" style="border-style: none solid solid none; border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; padding: 0px 5.4pt; text-align: right; background: rgb(79, 129, 189);" valign="bottom" width="71"><P><STRONG style="color: white; font-size: 9.0pt;">0.38</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: yellow; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="83"><P align="center" style="text-align: center;"><SPAN style="font-size: 9.0pt;">3rd</SPAN></P></TD><TD></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD></TD><TD></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="335"><P><SPAN style="font-size: 9.0pt; color: red;">*</SPAN><SPAN style="font-size: 9.0pt; color: black;"> Limit of 2nd quartile is 0.25. Hence, borrower's ratio of 0.38 will be parked under 3rd quartile.</SPAN></P></TD><TD nowrap="nowrap" style="border: none; border-left: solid white 1.5pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="71"><P><SPAN style="font-size: 9.0pt;"> </SPAN></P></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>All objects above are recursively calculated depending on what the user selects.</P><P></P><P>Thanks,</P><P>Jeffry</P></BODY></HTML> Thu, 17 Mar 2016 03:58:32 GMT https://community.qlik.com/t5/QlikView/Index-Match-formula-in-QlikView/m-p/1092759#M363293 2016-03-17T03:58:32Z