Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Including Peer Groups Set Analysis

I tried using the exclude E() function but not working quite right. Just trying to do something as simple show sales by customer AND sales for all other customers (Peer Group Sales) on the same line. Example below:

CustomerSalesPeer Group Sales
A2001800
B4001600
C6001400
D8001200

Zag

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Set analysis is evaluated once per chart, not per dimension line.

I think the easiest approach would be

=Sum(TOTAL Sales) - Sum(Sales)

to calculate the peer group sales.

View solution in original post

2 Replies
swuehl
MVP
MVP

Set analysis is evaluated once per chart, not per dimension line.

I think the easiest approach would be

=Sum(TOTAL Sales) - Sum(Sales)

to calculate the peer group sales.

zagzebski
Creator
Creator
Author

Thanks - worked great.