6 Replies Latest reply: Oct 26, 2015 9:15 AM by Jonathan Dienst

# Qlik Sense assessment Q&A doubt

What does this expression represent?

Sum({1-\$}Sales)

(A) The total sum of sales minus the sum of sales based on the current selections

(B) The sum of sales based on the current selections

(C) The percentage of the sum of sales for the current selections against the total

(D) The total sum of sales ignoring current selections

Can anyone tell me which option is correct.

Anyway what is the difference between option (A) and (D) .

• ###### Re: Qlik Sense assessment Q&A doubt

D)

Sum({1-\$} [Sales]) : sum of the sales in the application except the current selection

A) subtracts and D) Ignores

• ###### Re: Qlik Sense assessment Q&A doubt

This document is very useful.

• ###### Re: Qlik Sense assessment Q&A doubt

Hello Rangaraju,

I believe this is showing the total sum of sales minus current selections.

An example of ignoring the current selections can be found here:

Mark James

Qlik

• ###### Re: Qlik Sense assessment Q&A doubt

Hi Mark James,

Suppose for the option (D), instead of 'ignoring' if we have 'excluding' then option (A) and (D) would mean the same. Am I correct ?

• ###### Re: Qlik Sense assessment Q&A doubt

If you wanted A)

It would look like this.

Sum({1} [Sales]) : sum of everything (All dimensions are completly reset to All)

-

Sum({\$} [Sales]) : sum of the current selection

They are two different uses of set analysis and I guess there is a performance cost associated with each method.

Regards

Andy

• ###### Re: Qlik Sense assessment Q&A doubt

Rangaraju R wrote:

Suppose for the option (D), instead of 'ignoring' if we have 'excluding' then option (A) and (D) would mean the same. Am I correct ?

No.

(A) Excluding means taking all values, EXCEPT those that match the current selections.

(D) Ignoring selections means taking all values without regard to any user selections.