topic issue with sum .. no data shows .. sample included in QlikView https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203333#M60721 <HTML><HEAD></HEAD><BODY><P>/bump</P></BODY></HTML> Thu, 07 Jan 2010 08:27:47 GMT amien 2010-01-07T08:27:47Z issue with sum .. no data shows .. sample included https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203331#M60719 <HTML><HEAD></HEAD><BODY><P>1. shows the ordinary data</P><P>2. shows the same data only the values are capped until main value. This included a filenumber level.</P><P>3. now i need the same, but only without the filenumbers. so only the batchlevel and date. Now the pivot is empty..</P></BODY></HTML> Wed, 06 Jan 2010 22:17:56 GMT https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203331#M60719 amien 2010-01-06T22:17:56Z issue with sum .. no data shows .. sample included https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203332#M60720 <HTML><HEAD></HEAD><BODY><P>uploaded now..</P></BODY></HTML> Wed, 06 Jan 2010 22:33:10 GMT https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203332#M60720 amien 2010-01-06T22:33:10Z issue with sum .. no data shows .. sample included https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203333#M60721 <HTML><HEAD></HEAD><BODY><P>/bump</P></BODY></HTML> Thu, 07 Jan 2010 08:27:47 GMT https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203333#M60721 amien 2010-01-07T08:27:47Z issue with sum .. no data shows .. sample included https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203334#M60722 <HTML><HEAD></HEAD><BODY><P>is it really that hard? do i need AGGR()?</P></BODY></HTML> Fri, 08 Jan 2010 13:40:58 GMT https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203334#M60722 amien 2010-01-08T13:40:58Z issue with sum .. no data shows .. sample included https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203335#M60723 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In pivot 3 just delete the existing expression you have in there. Add new expression Sum(payment) .....I think thats it if I am understanding your question correctly.</P><P></P><P>Alan</P></BODY></HTML> Fri, 08 Jan 2010 13:52:59 GMT https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203335#M60723 2010-01-08T13:52:59Z issue with sum .. no data shows .. sample included https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203336#M60724 <HTML><HEAD></HEAD><BODY><P>nope .. in number 2 i have a horizontal total running .. using rangsum and before. .. based on a filenumber,date level.</P><P>now i want to remove the filenumber dimension and sum the payments by date .. that sum should be based on the values that i see in pivot number 2.</P><P>so.... i have a batch,filenumber and date in dimension .. and some calculation in expression.. the data that i see in that pivot, should be aggr by batch/vertical summed.</P><P class="CommonTitle">Sum within a calculated expression</P><P></P><P></P></BODY></HTML> Fri, 08 Jan 2010 14:10:56 GMT https://community.qlik.com/t5/QlikView/issue-with-sum-no-data-shows-sample-included/m-p/203336#M60724 amien 2010-01-08T14:10:56Z