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: 
zagzebski
Creator
Creator

TOTAL - Set Analysis

Data:

Client    Month   Sales

A             Jan       100

A             Feb        50      

B             Jan        200

B              Feb       100

I know this should be simlpe but I am drawing a blank on how to incorporate the TOTAL function. What I want to be able to do is add the total for each month regardless of the client:

Object:

Client   Month    Sales

A          Jan        300

B          Jan        300

A          Feb        150

B          Feb         150

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

May be with this

Sum(Total<Month> Sales)

View solution in original post

6 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

May be with this

Sum(Total<Month> Sales)

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Try this.

     Sum(total<Month>Sales)

     Where Client and Month is the dimension.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
MayilVahanan

HI

PFA

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
zagzebski
Creator
Creator
Author

Thanks - helped a lot!

Not applicable

In Straight Table Chart, take dimension as Month ans expression as sum(Sales). It will give you monthly total and grand total.

zagzebski
Creator
Creator
Author

I was slightly off in what I needed. I needed to segment by year:

Data:

Client    Month   Sales   Year

A             Jan       100   2013

A             Feb        50   2013   

B             Jan        200  2013

B              Feb      100  2013

A             Jan        75   2012

A             Feb        50   2012   

B             Jan        100  2012

B              Feb       75   2012

Object results:

Client   Month     Sales-2103   Sales-2012

A          Jan         300               175

B          Jan         300               175

A          Feb         150               125

B          Feb         150               125

Basically have to add Set analysis by year to this expression:Sum(total<Month>Sales)... but I must have my syntax wrong because I am coming back with blanks.