Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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

Re: Set analysis ( based on another field)

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


talk is cheap, supply exceeds demand
MVP
MVP

Re: Set analysis ( based on another field)

Try

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

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

Not applicable

Re: Set analysis ( based on another field)

Thanks!!!!

It works

Community Browser