Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
sunny_talwar

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))

View solution in original post

5 Replies
paulyeo11
Master
Master
Author

My QVF file

sunny_talwar

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

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
Master
Master
Author

Hi sunny

Thank you very much

Paul

paulyeo11
Master
Master
Author

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