# Qlik Sense App Development

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.

Paul

1 Solution

Accepted Solutions
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
Valued Contributor II

My QVF file

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)

Valued Contributor II

## Re: How to get Overall Total in QS Table ?

Hi sunny

Thank you very much

Paul

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