Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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 :


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.



Labels (2)
3 Replies

Re: Set analysis to omit selection

What exactly are you hoping to see? Just one row with the value?
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 🙂


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>
#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.