Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

patrickbender
New Contributor III

Set analysis to omit selection

Hi i would like to be able to get the total of both the rows using a set expression.

I tried to use :

=SUM({1}FSLEDGForeignCurrencyAmount)

But that destroys my current selections and all projects shows up.

I want to apply the "sum all" effect for the invoice level.

Hopefully someone understands what I try to accomplish.

Skärmklipp.PNG

 

Labels (2)
3 Replies

Re: Set analysis to omit selection

What exactly are you hoping to see? Just one row with the value?
Highlighted
patrickbender
New Contributor III

Re: Set analysis to omit selection

Yes that was the idea but couldn't do it without destroying the selection alternatives so I restructured the data.

Thank you for your time 🙂

Vegar
Honored Contributor

Re: Set analysis to omit selection

The SET analysis is considered for all dimensions in your table, to accomplish what you are trying to do you would need to use TOTAL.

=SUM(TOTAL <InvoiceNum>
FSLEDGForeignCurrencyAmount)
Please ekskuse my Norglish and Swenglish typos.