topic Conditional SUM in QlikView

Conditional SUM

Anonymous — Sat, 19 Dec 2015 12:44:33 GMT

Hello,

I need to sum just part of the FACTS in this way:

Suppose Facts Table

Customer Sales

A 20

B 20

C 30

A 50

I want an expression with total sales from Customers with sales greater then 60, in this case it would be 70.

What would be the expression?

Thanks in advance.

Prata

swuehl — Sat, 19 Dec 2015 13:14:31 GMT

Use set analysis with an advanced search in customer field:

=Sum({<Customer = {"=Sum(Sales)>60"}>} Sales)

reddy-s — Sat, 19 Dec 2015 18:51:47 GMT

Hi Ricardo,

This should help you as well.

sunny_talwar — Sun, 20 Dec 2015 00:01:58 GMT

This can be another way to do it, if you are doing this in a text box object:

Sum(Aggr(If(Sum(Sales) > 60, Sum(Sales)), Customer))

for a straight table use the below expression with Customer as your dimension

If(Sum(Sales) > 60, Sum(Sales))