topic Re: Problem in calculation in QlikView https://community.qlik.com/t5/QlikView/Problem-in-calculation/m-p/803280#M283576 <HTML><HEAD></HEAD><BODY><P>Can you provide the result you are looking for based on the data provided?</P></BODY></HTML> Sat, 14 Mar 2015 09:47:04 GMT MK_QSL 2015-03-14T09:47:04Z Problem in calculation https://community.qlik.com/t5/QlikView/Problem-in-calculation/m-p/803277#M283573 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have a problem i cant understand why this happen require expert advise i have pivot table with no any selection the table give me the wrong figures of two columns like this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 768pt; border-collapse: collapse;" width="1024"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="background-color: whitesmoke; width: 85pt; height: 12.75pt; border: gainsboro 0.5pt solid;" width="113"><STRONG style="color: #333333; font-family: Calibri;">NUM</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 84pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="112"><STRONG style="color: #333333; font-family: Calibri;">No. Of Disbursement</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 78pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="104"><STRONG style="color: #333333; font-family: Calibri;">Last Disbursal Date</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 89pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="119"><STRONG style="color: #333333; font-family: Calibri;">Last Disbursal Amount</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 89pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="119"><STRONG style="color: #333333; font-family: Calibri;">Disbursement Amount</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 76pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="101"><STRONG style="color: #333333; font-family: Calibri;">No. Of Withdrawal</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 87pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="116"><STRONG style="color: #333333; font-family: Calibri;">Last Withdrawal Date</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 99pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="132"><STRONG style="color: #333333; font-family: Calibri;">Last Withdrawal Amount</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 81pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="108"><STRONG style="color: #333333; font-family: Calibri;">Withdrawal Amount</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="background-color: transparent; height: 12.75pt; border: #f0f0f0;"><SPAN style="color: #000000;">789453</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">9</SPAN></TD><TD style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">19-01-2015</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">0</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">34200</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">6</SPAN></TD><TD style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">18-12-2014</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">0</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">32000</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="background-color: transparent; height: 12.75pt; border: #f0f0f0;"><SPAN style="color: #000000;">452125</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">11</SPAN></TD><TD style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">18-12-2014</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">0</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">38400</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">5</SPAN></TD><TD style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">18-12-2015</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">0</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">38000</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="background-color: transparent; height: 12.75pt; border: #f0f0f0;"><SPAN style="color: #000000;">548712</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">11</SPAN></TD><TD style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">18-12-2014</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">0</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">38400</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">9</SPAN></TD><TD style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">18-12-2016</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">0</SPAN></TD><TD align="right" style="background-color: transparent; border: #f0f0f0;"><SPAN style="color: #000000;">38000</SPAN></TD></TR></TBODY></TABLE><P></P><P>and when i select the list box num it give the the right figure</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 763pt; border-collapse: collapse;" width="1018"><TBODY><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="background-color: whitesmoke; width: 75pt; height: 12.75pt; border: gainsboro 0.5pt solid;" width="100"><STRONG style="color: #333333; font-family: Calibri;">NUM</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 74pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="98"><STRONG style="color: #333333; font-family: Calibri;">No. Of Disbursement</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 78pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="104"><STRONG style="color: #333333; font-family: Calibri;">Last Disbursal Date</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 89pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="119"><STRONG style="color: #333333; font-family: Calibri;">Last Disbursal Amount</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 89pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="119"><STRONG style="color: #333333; font-family: Calibri;">Disbursement Amount</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 86pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="115"><STRONG style="color: #333333; font-family: Calibri;">No. Of Withdrawal</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 87pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="116"><STRONG style="color: #333333; font-family: Calibri;">Last Withdrawal Date</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 92pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="123"><STRONG style="color: #333333; font-family: Calibri;">Last Withdrawal Amount</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 93pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="124"><STRONG style="color: #333333; font-family: Calibri;">Withdrawal Amount</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">124578</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">11</SPAN></TD><TD align="right" class="xl68" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">18-12-2014</SPAN></TD><TD class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">4500</SPAN></TD><TD class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">38400</SPAN></TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">11</SPAN></TD><TD align="right" class="xl68" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">19-12-2014</SPAN></TD><TD class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">4500</SPAN></TD><TD class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"><SPAN style="font-family: Calibri; color: #333333;">38000</SPAN></TD></TR></TBODY></TABLE><P> <BR />the num is mu dimenshion and remaining is my expressions..</P><P></P><P>Prompt response is highly appreciated</P></BODY></HTML> Sat, 14 Mar 2015 05:41:50 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculation/m-p/803277#M283573 2015-03-14T05:41:50Z Re: Problem in calculation https://community.qlik.com/t5/QlikView/Problem-in-calculation/m-p/803278#M283574 <HTML><HEAD></HEAD><BODY><P>124578? Where it is?</P><P>Provide proper data to work..</P></BODY></HTML> Sat, 14 Mar 2015 09:28:54 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculation/m-p/803278#M283574 MK_QSL 2015-03-14T09:28:54Z Re: Problem in calculation https://community.qlik.com/t5/QlikView/Problem-in-calculation/m-p/803279#M283575 <HTML><HEAD></HEAD><BODY><P>this is dummy data just for understanding and i want the amount of last disbursal date.</P></BODY></HTML> Sat, 14 Mar 2015 09:41:28 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculation/m-p/803279#M283575 2015-03-14T09:41:28Z Re: Problem in calculation https://community.qlik.com/t5/QlikView/Problem-in-calculation/m-p/803280#M283576 <HTML><HEAD></HEAD><BODY><P>Can you provide the result you are looking for based on the data provided?</P></BODY></HTML> Sat, 14 Mar 2015 09:47:04 GMT https://community.qlik.com/t5/QlikView/Problem-in-calculation/m-p/803280#M283576 MK_QSL 2015-03-14T09:47:04Z