topic Re: distinct sum not working in QlikView https://community.qlik.com/t5/QlikView/distinct-sum-not-working/m-p/469339#M488269 <HTML><HEAD></HEAD><BODY><P>use this expression hope it helps you</P><P>SUM( {$<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">(</SPAN><SPAN style="background-color: #ffffff; font-family: Arial; color: #800000;">[Posting Date]</SPAN>={$(#=min(<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">(</SPAN><SPAN style="background-color: #ffffff; font-family: Arial; color: #800000;">[Posting Date]</SPAN>))}&gt;}DISTINCT<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> </SPAN><SPAN style="background-color: #ffffff; font-family: Arial; color: #800000;">[INV_DOCPAYAMT]</SPAN>)</P></BODY></HTML> Fri, 28 Dec 2012 06:35:33 GMT er_mohit 2012-12-28T06:35:33Z distinct sum not working https://community.qlik.com/t5/QlikView/distinct-sum-not-working/m-p/469336#M488266 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P><SPAN style="color: #0000ff; font-size: 10pt;">I have following expression not giving&nbsp; any result&nbsp; i want to sum distinct for opening balance</SPAN></P><P><SPAN style="color: #0000ff; font-size: 10pt;">&nbsp; </SPAN></P><P><SPAN style="color: #0000ff; font-size: 10pt;"></SPAN></P><P>SUM<SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">DISTINCT</SPAN><SPAN style="font-size: 10pt;">{$&lt;</SPAN><SPAN style="color: #800000; font-size: 10pt;">[Posting Date]</SPAN><SPAN style="font-size: 10pt;">={</SPAN><SPAN style="color: #800000; font-size: 10pt;">"&lt;$(=min([Posting Date]))"</SPAN><SPAN style="font-size: 10pt;">} &gt;} </SPAN><SPAN style="color: #800000; font-size: 10pt;">[INV_DOCPAYAMT]</SPAN><SPAN style="font-size: 10pt;">) </SPAN></P><P></P><P></P><P></P><P>Any one help me pls</P><P></P><P>Thanks </P><P></P><P>Vikas</P></BODY></HTML> Fri, 28 Dec 2012 04:57:33 GMT https://community.qlik.com/t5/QlikView/distinct-sum-not-working/m-p/469336#M488266 vikasmahajan 2012-12-28T04:57:33Z Re: distinct sum not working https://community.qlik.com/t5/QlikView/distinct-sum-not-working/m-p/469337#M488267 <HTML><HEAD></HEAD><BODY><P>sum({&lt;<SPAN style="color: #800000; font-family: Arial; background-color: #ffffff;">[Posting Date]</SPAN>={"&lt;=$(=vMinDate)"} &gt;} distinct <SPAN style="color: #800000; font-family: Arial; background-color: #ffffff;">[INV_DOCPAYAMT]</SPAN>)</P><P></P><P>LET vMinDate = min(<SPAN style="color: #800000; font-family: Arial; background-color: #ffffff;">[Posting Date]</SPAN>)</P><P></P><P></P><P>Try to use this formula....</P><P></P><P>Hope this will&nbsp; help you ! ! ! </P><P></P><P>Regards,</P><P>Nitin Jain</P></BODY></HTML> Fri, 28 Dec 2012 05:45:27 GMT https://community.qlik.com/t5/QlikView/distinct-sum-not-working/m-p/469337#M488267 2012-12-28T05:45:27Z Re: distinct sum not working https://community.qlik.com/t5/QlikView/distinct-sum-not-working/m-p/469338#M488268 <HTML><HEAD></HEAD><BODY><P>hi </P><P>try it.</P><P><STRONG>sum({$&lt;</STRONG><SPAN style="color: #800000; font-size: 10pt;">[Posting Date]</SPAN><STRONG>={$(#=only(</STRONG><SPAN style="color: #800000; font-size: 10pt;">[Posting Date]</SPAN><STRONG>)-1)},</STRONG><SPAN style="color: #800000; font-size: 10pt;">[Posting Date]</SPAN><STRONG>=&gt;}DISTINCT </STRONG><SPAN style="color: #800000; font-size: 10pt;">[INV_DOCPAYAMT]</SPAN><STRONG>)</STRONG></P><P>hope this helps you.</P></BODY></HTML> Fri, 28 Dec 2012 06:16:30 GMT https://community.qlik.com/t5/QlikView/distinct-sum-not-working/m-p/469338#M488268 2012-12-28T06:16:30Z Re: distinct sum not working https://community.qlik.com/t5/QlikView/distinct-sum-not-working/m-p/469339#M488269 <HTML><HEAD></HEAD><BODY><P>use this expression hope it helps you</P><P>SUM( {$<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">(</SPAN><SPAN style="background-color: #ffffff; font-family: Arial; color: #800000;">[Posting Date]</SPAN>={$(#=min(<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">(</SPAN><SPAN style="background-color: #ffffff; font-family: Arial; color: #800000;">[Posting Date]</SPAN>))}&gt;}DISTINCT<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"> </SPAN><SPAN style="background-color: #ffffff; font-family: Arial; color: #800000;">[INV_DOCPAYAMT]</SPAN>)</P></BODY></HTML> Fri, 28 Dec 2012 06:35:33 GMT https://community.qlik.com/t5/QlikView/distinct-sum-not-working/m-p/469339#M488269 er_mohit 2012-12-28T06:35:33Z