topic Re: Including Peer Groups Set Analysis in QlikView

Including Peer Groups Set Analysis

zagzebski — Tue, 24 Nov 2015 15:14:24 GMT

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:

Customer	Sales	Peer Group Sales
A	200	1800
B	400	1600
C	600	1400
D	800	1200

Zag

Re: Including Peer Groups Set Analysis

swuehl — Tue, 24 Nov 2015 15:18:24 GMT

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.

Re: Including Peer Groups Set Analysis

zagzebski — Tue, 24 Nov 2015 22:17:18 GMT

Thanks - worked great.