Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
patrickbender
Contributor III
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
sunny_talwar

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

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
MVP
MVP

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)