topic Re: Aggr giving error with partial sum in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365542#M417977 <HTML><HEAD></HEAD><BODY><P>Hi Kushal,</P><P></P><P>Actually its 5 level variable used previously so I decided not to disturb that. and</P><P>I'm getting wrong on Summary and Summary% sheets with charts named as <STRONG>summary/sumaary%</STRONG> using value list.</P><P>In OEE% YTD I'm getting 92.87 what we need is 46.44 .</P></BODY></HTML> Thu, 18 May 2017 09:11:04 GMT Anonymous 2017-05-18T09:11:04Z Aggr giving error with partial sum in Qlikview https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365538#M417973 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need to display YTD but as per clients requirements I had to make few changes in given chart. As YTD i'm unable to display given partial sum for OEE %.</P><P>Please have a look and let me know if any possible solution .</P><P>Open to any other suggestions for displaying YTD.</P><P></P><P>Attach given file . Please look in&nbsp; Summary and Summary% tab. </P></BODY></HTML> Thu, 18 May 2017 05:52:56 GMT https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365538#M417973 Anonymous 2017-05-18T05:52:56Z Re: Aggr giving error with partial sum in Qlikview https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365539#M417974 <HTML><HEAD></HEAD><BODY><P>Definitely, We can help you. Can you help us to find out the issue? Seems OEE% YTD works to me</P></BODY></HTML> Thu, 18 May 2017 06:26:58 GMT https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365539#M417974 Anil_Babu_Samineni 2017-05-18T06:26:58Z Re: Aggr giving error with partial sum in Qlikview https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365540#M417975 <HTML><HEAD></HEAD><BODY><P>Would you be able to give actual final expression without variable? And in which chart you are getting wrong results? what is expected result?</P></BODY></HTML> Thu, 18 May 2017 07:24:29 GMT https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365540#M417975 Kushal_Chawda 2017-05-18T07:24:29Z Re: Aggr giving error with partial sum in Qlikview https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365541#M417976 <HTML><HEAD></HEAD><BODY><P>Nope check it is showing addition of given percentages.. What I need is just like you can see in Capacity utilization.</P><P>Ans is 46.44%</P><P></P><P>You can put this expression in OEE5 and Check :</P><P></P><P>//Num((RangeAvg(Before(sum(Aggr(($(vOEE)*$(vWeight))/100, FMonth,CellType,Cell,List2)),0,RowNo(TOTAL)))), '#0.## %')&nbsp; </P><P></P><P>I need this value in YTD not under max month.</P><P><SPAN class="mce_paste_marker"></SPAN></P></BODY></HTML> Thu, 18 May 2017 09:06:01 GMT https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365541#M417976 Anonymous 2017-05-18T09:06:01Z Re: Aggr giving error with partial sum in Qlikview https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365542#M417977 <HTML><HEAD></HEAD><BODY><P>Hi Kushal,</P><P></P><P>Actually its 5 level variable used previously so I decided not to disturb that. and</P><P>I'm getting wrong on Summary and Summary% sheets with charts named as <STRONG>summary/sumaary%</STRONG> using value list.</P><P>In OEE% YTD I'm getting 92.87 what we need is 46.44 .</P></BODY></HTML> Thu, 18 May 2017 09:11:04 GMT https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365542#M417977 Anonymous 2017-05-18T09:11:04Z Re: Aggr giving error with partial sum in Qlikview https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365543#M417978 <HTML><HEAD></HEAD><BODY><P>try below formula</P><P></P><P><STRONG><EM>Num((if(SecondaryDimensionality()=1,(sum(Aggr(($(vOEE)*$(vWeight))/100, FMonth,CellType,Cell,List2))),</EM></STRONG></P><P><STRONG><EM>sum(Aggr(($(vOEE)*$(vWeight))/100,FMonth,CellType,Cell,List2))/Count(DISTINCT CalendarYear&amp;CalendarMonth))), '#0.## %') </EM></STRONG></P></BODY></HTML> Thu, 18 May 2017 09:49:12 GMT https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365543#M417978 Kushal_Chawda 2017-05-18T09:49:12Z Re: Aggr giving error with partial sum in Qlikview https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365544#M417979 <HTML><HEAD></HEAD><BODY><P>Thanks a lot .It worked.</P></BODY></HTML> Thu, 18 May 2017 10:40:38 GMT https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365544#M417979 Anonymous 2017-05-18T10:40:38Z Re: Aggr giving error with partial sum in Qlikview https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365545#M417980 <HTML><HEAD></HEAD><BODY><P>np <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 18 May 2017 10:42:16 GMT https://community.qlik.com/t5/QlikView/Aggr-giving-error-with-partial-sum-in-Qlikview/m-p/1365545#M417980 Kushal_Chawda 2017-05-18T10:42:16Z