Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

raju_insights
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
mjm
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:

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

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

Mark James

Qlik

6 Replies
ogster1974
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

ogster1974
Honored Contributor II

Re: Qlik Sense assessment Q&A doubt

This document is very useful.

mjm
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:

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

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

Mark James

Qlik

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

ogster1974
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
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
Community Browser