# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor III

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

Tags (1)
1 Solution

Accepted Solutions
Contributor III

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

6 Replies
Honored Contributor II

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

Honored Contributor II

## Re: Qlik Sense assessment Q&A doubt

This document is very useful.

Contributor III

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

Contributor III

## 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 ?

Honored Contributor II

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

MVP

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein