Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rdimarco
New Contributor

Aggregation used as filter in Set Analysis

Hi everybody,

I know it´s a simple question but it seems like I can´t solve it myself.

I have some data that contains a list of invoices owned by a certain company. I want to be able to show only those companies whose invoices total less than a certain amount due, like 100.000, or range, like between 100.000 and 200.000.

I made an aggregation that works well (alone):

          Aggr(NODISTINCT Sum(TotalOwned), [Client])

where TotalOwned is the value field of the invoice. It groups all the invoices due by a client and shows the total owned.

But when I try to use that value as a filter on a set Analysis, I get nothing:

          Sum({$<{"$(=Aggr(Sum(TotalOwned),Client)) < 100000"}>} TotalOwned)

Any suggestion is welcomed.

Thanks in advance!

1 Solution

Accepted Solutions

Re: Aggregation used as filter in Set Analysis

Try this

Sum({<Client = {"=Sum(TotalOwned) < 100000"}>}TotalOwned)

2 Replies

Re: Aggregation used as filter in Set Analysis

Try this

Sum({<Client = {"=Sum(TotalOwned) < 100000"}>}TotalOwned)

rdimarco
New Contributor

Re: Aggregation used as filter in Set Analysis

It works! Thanks a lot, Sunny.

Community Browser