Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

How to get Overall Total in QS Table ?

Hi All

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.

Can some one advise me.

Paul

1 Solution

Accepted Solutions
MVP
MVP

Re: How to get Overall Total in QS Table ?

May be use Aggr()

Sum(Aggr(

Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}, eXP={"eXP"} >} Amount*-1)/Rate/1000,

SOURCE))

5 Replies
paulyeo11
Valued Contributor II

Re: How to get Overall Total in QS Table ?

My QVF file

MVP
MVP

Re: How to get Overall Total in QS Table ?

May be use Aggr()

Sum(Aggr(

Sum({<year = {$(=Max(if(getselectedcount(year)=0,2015,year))-0)} , month = {"<=$(=Max({<year={$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}, eXP={"eXP"} >} Amount*-1)/Rate/1000,

SOURCE))

Not applicable

Re: How to get Overall Total in QS Table ?

Hi Paul

You can use the 'Total' keyword in a sum function to calculate the total across all dimensions for you eXP field 

=Sum(Total  eXP)

paulyeo11
Valued Contributor II

Re: How to get Overall Total in QS Table ?

Hi sunny

Thank you very much

Paul

paulyeo11
Valued Contributor II

Re: How to get Overall Total in QS Table ?

Hi sir

Can you help me by example ? I mean show me using the QVF file on how you make overall total display out .

Paul

Sent from my iPhone