Qlik Sense assessment Q&A doubt

[raju_insights]

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) .

[ogster1974]

D)

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

A) subtracts and D) Ignores

[ogster1974]

This document is very useful.

[mjm · Accepted solution]

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:

https://www.qlikcommunity.com/thread/184330

Please mark this response as helpful if this helps to answer your question

Mark James

Qlik

[raju_insights]

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 ?

[ogster1974]

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

[jonathandienst]

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.