topic Re: Set analysis ( based on another field) in QlikView

Set analysis ( based on another field)

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I´m trying , using Set Analysis, to filter the information in my table

It´s possible to obtain the sum of the amounts, but only invoices not repeated.

Something like this:

"Sum({$<DISTINCT Invoice>}Amount)"

Invoice Amount

1 15

2 35

3 25

2 35

4 15

5 40

TOTAL 130

Thanks

Gysbert_Wassenaar — Thu, 11 Feb 2016 16:16:47 GMT

sum({<Invoice={"=count(Invoice)=1"}>}Amount)

swuehl — Thu, 11 Feb 2016 16:21:12 GMT

Try

=Sum( Aggr( Only( Amount), Invoice))

But I would rather remodel the model to avoid the duplicate facts.

Fri, 12 Feb 2016 12:24:03 GMT

Thanks!!!!

It works