Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis ( based on another field)

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

4                15

5                40

  TOTAL   130



Thanks

3 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
swuehl
MVP
MVP

Try

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

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

Not applicable
Author

Thanks!!!!

It works