topic Re: Load distinct amount in details table in QlikView https://community.qlik.com/t5/QlikView/Load-distinct-amount-in-details-table/m-p/463100#M172932 <HTML><HEAD></HEAD><BODY><P></P><P>Hi Vikas,</P><P>Come up with an example output required, then it is easier to understand what you required, It is possible.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 24 Dec 2012 10:28:57 GMT jagan 2012-12-24T10:28:57Z Load distinct amount in details table https://community.qlik.com/t5/QlikView/Load-distinct-amount-in-details-table/m-p/463098#M172930 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>I have table invdet which has&nbsp; inv_docpayamt column this is total of header which is repetaing with details total</P><P>now i want to display only one time 65063&nbsp; amt with details table , Whether this is possible in QV. I have attach</P><P>QV file also </P><P></P><P></P><P>Advance Thanks.</P><P></P><P>Regards</P><P></P><P>Vikas</P><P></P><P></P><P></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="35" style="width: 63px; height: 32px;" width="61"><TBODY><TR><TD class="xl63" height="35" width="129"></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 24 Dec 2012 05:18:49 GMT https://community.qlik.com/t5/QlikView/Load-distinct-amount-in-details-table/m-p/463098#M172930 vikasmahajan 2012-12-24T05:18:49Z Re: Load distinct amount in details table https://community.qlik.com/t5/QlikView/Load-distinct-amount-in-details-table/m-p/463099#M172931 <HTML><HEAD></HEAD><BODY><P>use distinct function might be helpful</P><P>like</P><P>sum(distinct <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> inv_docpayamt</SPAN>)</P><P>hope it helps you</P></BODY></HTML> Mon, 24 Dec 2012 06:04:16 GMT https://community.qlik.com/t5/QlikView/Load-distinct-amount-in-details-table/m-p/463099#M172931 er_mohit 2012-12-24T06:04:16Z Re: Load distinct amount in details table https://community.qlik.com/t5/QlikView/Load-distinct-amount-in-details-table/m-p/463100#M172932 <HTML><HEAD></HEAD><BODY><P></P><P>Hi Vikas,</P><P>Come up with an example output required, then it is easier to understand what you required, It is possible.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 24 Dec 2012 10:28:57 GMT https://community.qlik.com/t5/QlikView/Load-distinct-amount-in-details-table/m-p/463100#M172932 jagan 2012-12-24T10:28:57Z