topic Re: Orphan Table Lookup in QlikView https://community.qlik.com/t5/QlikView/Orphan-Table-Lookup/m-p/1362226#M825680 <HTML><HEAD></HEAD><BODY><P>What i am assuming is, First do Cross table for 1st rate and 2nd rate and then use name as Sales. </P></BODY></HTML> Tue, 11 Jul 2017 10:15:56 GMT Anil_Babu_Samineni 2017-07-11T10:15:56Z Orphan Table Lookup https://community.qlik.com/t5/QlikView/Orphan-Table-Lookup/m-p/1362225#M825679 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>I have an Orphan table </P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 268px;"><TBODY><TR><TD class="xl66" colspan="4" height="20" width="268"></TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">Min</TD><TD class="xl63" style="border-top: none; border-left: none;">Max</TD><TD class="xl63" style="border-top: none; border-left: none;">1st Rate</TD><TD class="xl63" style="border-top: none; border-left: none;">2nd Rate</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">500</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">5,00%</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">4,00%</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">500,01</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4,75%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3,80%</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">1000,01</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4,51%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3,61%</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">1500,01</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">2000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4,29%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3,43%</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">2000,01</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">2500</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4,07%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3,26%</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">2500,01</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">12000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3,87%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3,10%</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">12000,01</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">15000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3,68%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2,94%</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">15000,01</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3,49%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2,79%</TD></TR><TR><TD align="right" class="xl63" height="20" style="border-top: none;">20000,01</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100000</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">3,32%</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2,65%</TD></TR></TBODY></TABLE><P></P><P>I then have a sum of Sales calculation that i need to evaluate against this table and return 1st and 2nd rate, i havn't a clue where to start, please can anyone assist?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Orphan-Table-Lookup/m-p/1362225#M825679 2020-11-25T16:16:04Z Re: Orphan Table Lookup https://community.qlik.com/t5/QlikView/Orphan-Table-Lookup/m-p/1362226#M825680 <HTML><HEAD></HEAD><BODY><P>What i am assuming is, First do Cross table for 1st rate and 2nd rate and then use name as Sales. </P></BODY></HTML> Tue, 11 Jul 2017 10:15:56 GMT https://community.qlik.com/t5/QlikView/Orphan-Table-Lookup/m-p/1362226#M825680 Anil_Babu_Samineni 2017-07-11T10:15:56Z