topic Re: How to write an Sum expression? in QlikView https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333738#M411741 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Yes, it has given me the correct figure. </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Can you show me how to write in a set analysis??</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Rgds</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Jim</P></BODY></HTML> Tue, 04 Apr 2017 05:39:33 GMT jim_chan 2017-04-04T05:39:33Z How to write an Sum expression? https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333734#M411737 <HTML><HEAD></HEAD><BODY><P>Hi guys, </P><P></P><P>I would like to write an set analysis. </P><P></P><P>i have attached screenshot. </P><P></P><P>1) i have a straight table. i have a normal expression. sum(tree_population_points). </P><P>2) i am unable to sum up correctly. It should not show 7. </P><P>3) the total sum should be 18. </P><P></P><P>so, how can i get that sum??? group by? aggr???</P><P></P><P>Rgds</P><P></P><P>Jim </P></BODY></HTML> Tue, 04 Apr 2017 05:33:35 GMT https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333734#M411737 jim_chan 2017-04-04T05:33:35Z Re: How to write an Sum expression? https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333735#M411738 <HTML><HEAD></HEAD><BODY><P>It will work direct way - May be this? <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>sum(TOTAL tree_population_points)</STRONG></SPAN></P><P></P><P>Or change your expression like below</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/158781_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 04 Apr 2017 05:36:01 GMT https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333735#M411738 Anil_Babu_Samineni 2017-04-04T05:36:01Z Re: How to write an Sum expression? https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333736#M411739 <HTML><HEAD></HEAD><BODY><P>Use total mode 'Sum of rows' in the expression tab.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/158782_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 04 Apr 2017 05:37:37 GMT https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333736#M411739 tresB 2017-04-04T05:37:37Z Re: How to write an Sum expression? https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333737#M411740 <HTML><HEAD></HEAD><BODY><P>Yes, it has given me the correct figure. </P><P></P><P>Can you show me how to write in a set analysis??</P><P></P><P>Rgds</P><P></P><P>Jim</P></BODY></HTML> Tue, 04 Apr 2017 05:39:25 GMT https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333737#M411740 jim_chan 2017-04-04T05:39:25Z Re: How to write an Sum expression? https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333738#M411741 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Yes, it has given me the correct figure. </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Can you show me how to write in a set analysis??</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Rgds</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Jim</P></BODY></HTML> Tue, 04 Apr 2017 05:39:33 GMT https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333738#M411741 jim_chan 2017-04-04T05:39:33Z Re: How to write an Sum expression? https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333739#M411742 <HTML><HEAD></HEAD><BODY><P>i have tried with <SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">sum(TOTAL tree_population_points)</STRONG></SPAN></P><P></P><P>it gives me the wrong value - which is 7.</P></BODY></HTML> Tue, 04 Apr 2017 05:43:43 GMT https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333739#M411742 jim_chan 2017-04-04T05:43:43Z Re: How to write an Sum expression? https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333740#M411743 <HTML><HEAD></HEAD><BODY><P>For me, It's working with simple aggregation also. Would you share sample</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/158784_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 04 Apr 2017 05:45:57 GMT https://community.qlik.com/t5/QlikView/How-to-write-an-Sum-expression/m-p/1333740#M411743 Anil_Babu_Samineni 2017-04-04T05:45:57Z