topic Re: Problem with Sum in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992767#M955970 <HTML><HEAD></HEAD><BODY><P>Try as <A href="https://community.qlik.com/qlik-users/96544">gwassenaar</A>‌ have told but with a little difference:</P><P></P><P>=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FirstSortedValue(Sum(Stock_réel), -Date_Mvt)</SPAN></P></BODY></HTML> Fri, 13 Nov 2015 14:32:07 GMT miguelbraga 2015-11-13T14:32:07Z Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992763#M955966 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a problem with a Sum in my board. If I reduce my board has the article or in the month I shall wish to have for it "stock_réel" the last value of my lines which display( ex here : 525)</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105437_Capture.JPG" style="height: auto;" /></P><P>When i reduce i have this </P><P><IMG alt="Capture2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/105438_Capture2.JPG" style="height: auto;" /></P><P></P><P>anyone can help me please?</P></BODY></HTML> Fri, 13 Nov 2015 12:52:31 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992763#M955966 2015-11-13T12:52:31Z Re: Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992764#M955967 <HTML><HEAD></HEAD><BODY><P>Try FirstSortedValue(Stock_réel, -Date_Mvt)</P></BODY></HTML> Fri, 13 Nov 2015 13:43:05 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992764#M955967 Gysbert_Wassenaar 2015-11-13T13:43:05Z Re: Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992765#M955968 <HTML><HEAD></HEAD><BODY><P>Hello, Thanks to help me but is not working</P><P><IMG alt="Capture3.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105455_Capture3.JPG" style="height: 57px; width: 620px;" /></P></BODY></HTML> Fri, 13 Nov 2015 14:10:47 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992765#M955968 2015-11-13T14:10:47Z Re: Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992766#M955969 <HTML><HEAD></HEAD><BODY><P>Please post a small qlikview document that demonstrates the problem.</P></BODY></HTML> Fri, 13 Nov 2015 14:25:58 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992766#M955969 Gysbert_Wassenaar 2015-11-13T14:25:58Z Re: Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992767#M955970 <HTML><HEAD></HEAD><BODY><P>Try as <A href="https://community.qlik.com/qlik-users/96544">gwassenaar</A>‌ have told but with a little difference:</P><P></P><P>=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FirstSortedValue(Sum(Stock_réel), -Date_Mvt)</SPAN></P></BODY></HTML> Fri, 13 Nov 2015 14:32:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992767#M955970 miguelbraga 2015-11-13T14:32:07Z Re: Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992768#M955971 <HTML><HEAD></HEAD><BODY><P>A little demo </P></BODY></HTML> Fri, 13 Nov 2015 15:30:10 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992768#M955971 2015-11-13T15:30:10Z Re: Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992769#M955972 <HTML><HEAD></HEAD><BODY><P>Same results no working</P><P></P><P>thanks</P></BODY></HTML> Fri, 13 Nov 2015 15:31:16 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992769#M955972 2015-11-13T15:31:16Z Re: Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992770#M955973 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>Do you mean that the sum of the values when collapses is different&nbsp; than the sum when it expands</P></BODY></HTML> Fri, 13 Nov 2015 15:49:33 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992770#M955973 2015-11-13T15:49:33Z Re: Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992771#M955974 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Fri, 13 Nov 2015 17:06:35 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992771#M955974 Gysbert_Wassenaar 2015-11-13T17:06:35Z Re: Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992772#M955975 <HTML><HEAD></HEAD><BODY><P>Thanks so much for the help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Mon, 16 Nov 2015 07:14:59 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992772#M955975 2015-11-16T07:14:59Z Re: Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992773#M955976 <HTML><HEAD></HEAD><BODY><P>I have other problem maybe you can help me :</P><P></P><P>On my board the operation for sum not working:</P><P></P><P><SPAN style="color: #000000; font-family: Tahoma, Verdana, Arial, Helvetica, sans-serif; font-size: 12px; background-color: #efefef;">Normally I leave QTY and I subtract every operation of movement of the result obtained previously.</SPAN></P><P></P><P><SPAN style="color: #000000; font-family: Tahoma, Verdana, Arial, Helvetica, sans-serif; font-size: 12px; background-color: #efefef;">Except here the problem is that it&nbsp; takes me all the time the value of the original stock for the subtraction instead of the result obtained after the movements.</SPAN></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105587_Capture.JPG" style="height: 254px; width: 620px;" /></P><P><IMG alt="Capture2.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/105588_Capture2.jpg" style="height: 254px; width: 620px;" /></P><P>If you have a solution <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 16 Nov 2015 10:18:13 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992773#M955976 2015-11-16T10:18:13Z Re: Problem with Sum https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992774#M955977 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">I have other problem maybe you can help me :</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">On my board the operation for sum not working:</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="color: #000000; font-family: Tahoma, Verdana, Arial, Helvetica, sans-serif; font-size: 12px; background-color: #efefef;">Normally I leave QTY and I subtract every operation of movement of the result obtained previously.</SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="color: #000000; font-family: Tahoma, Verdana, Arial, Helvetica, sans-serif; font-size: 12px; background-color: #efefef;">Except here the problem is that it&nbsp; takes me all the time the value of the original stock for the subtraction instead of the result obtained after the movements.</SPAN></P><P style="font-size: 13.3333px;"><IMG __jive_id="105587" alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105650_Capture.JPG" style="height: 254px; width: 620px;" /></P><P style="font-size: 13.3333px;"><IMG __jive_id="105588" alt="Capture2.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/105651_Capture2.jpg" style="height: 254px; width: 620px;" /></P><P style="font-size: 13.3333px;">If you have a solution <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 16 Nov 2015 13:38:29 GMT https://community.qlik.com/t5/QlikView/Problem-with-Sum/m-p/992774#M955977 2015-11-16T13:38:29Z