topic Re: How to get Overall Total in QS Table ? in App Development https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013420#M15036 <HTML><HEAD></HEAD><BODY><P>May be use Aggr()</P><P></P><P><STRONG>Sum(Aggr(</STRONG></P><P><STRONG>Sum({&lt;year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"&lt;=$(=Max({&lt;year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}&gt;} month))"}, eXP={"eXP"} &gt;} Amount*-1)/Rate/1000,</STRONG></P><P><STRONG>SOURCE))</STRONG></P></BODY></HTML> Tue, 12 Apr 2016 07:33:38 GMT sunny_talwar 2016-04-12T07:33:38Z How to get Overall Total in QS Table ? https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013418#M15034 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P style="font-family: 'QlikView Sans', sans-serif; color: #545352; font-size: 15.924px;"></P><P style="font-family: 'QlikView Sans', sans-serif; color: #545352; font-size: 15.924px;">I have a QS Table , i need the overall total amount , now it can display overall total on NO OF Staff 55 , but it cannot display eXP overall Total.</P><P style="font-family: 'QlikView Sans', sans-serif; color: #545352; font-size: 15.924px;"></P><P style="font-family: 'QlikView Sans', sans-serif; color: #545352; font-size: 15.924px;">Can some one advise me.</P><P style="font-family: 'QlikView Sans', sans-serif; color: #545352; font-size: 15.924px;"></P><P style="font-family: 'QlikView Sans', sans-serif; color: #545352; font-size: 15.924px;">Paul</P></BODY></HTML> Tue, 12 Apr 2016 07:24:20 GMT https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013418#M15034 paulyeo11 2016-04-12T07:24:20Z Re: How to get Overall Total in QS Table ? https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013419#M15035 <HTML><HEAD></HEAD><BODY><P>My QVF file</P></BODY></HTML> Tue, 12 Apr 2016 07:25:09 GMT https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013419#M15035 paulyeo11 2016-04-12T07:25:09Z Re: How to get Overall Total in QS Table ? https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013420#M15036 <HTML><HEAD></HEAD><BODY><P>May be use Aggr()</P><P></P><P><STRONG>Sum(Aggr(</STRONG></P><P><STRONG>Sum({&lt;year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"&lt;=$(=Max({&lt;year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}&gt;} month))"}, eXP={"eXP"} &gt;} Amount*-1)/Rate/1000,</STRONG></P><P><STRONG>SOURCE))</STRONG></P></BODY></HTML> Tue, 12 Apr 2016 07:33:38 GMT https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013420#M15036 sunny_talwar 2016-04-12T07:33:38Z Re: How to get Overall Total in QS Table ? https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013421#M15037 <HTML><HEAD></HEAD><BODY><P>Hi Paul</P><P></P><P>You can use the 'Total' keyword in a sum function to calculate the total across all dimensions for you eXP field&nbsp; </P><P>=Sum(Total&nbsp; eXP)</P></BODY></HTML> Tue, 12 Apr 2016 07:47:39 GMT https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013421#M15037 2016-04-12T07:47:39Z Re: How to get Overall Total in QS Table ? https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013422#M15038 <HTML><HEAD></HEAD><BODY><P>Hi sunny</P><P></P><P>Thank you very much</P><P></P><P>Paul</P></BODY></HTML> Tue, 12 Apr 2016 07:49:40 GMT https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013422#M15038 paulyeo11 2016-04-12T07:49:40Z Re: How to get Overall Total in QS Table ? https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013423#M15039 <HTML><HEAD></HEAD><BODY><P>Hi sir</P><P></P><P>Can you help me by example ? I mean show me using the QVF file on how you make overall total display out .</P><P></P><P>Paul</P><P></P><P>Sent from my iPhone</P></BODY></HTML> Tue, 12 Apr 2016 11:38:15 GMT https://community.qlik.com/t5/App-Development/How-to-get-Overall-Total-in-QS-Table/m-p/1013423#M15039 paulyeo11 2016-04-12T11:38:15Z