Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
raju_insights
Partner - Creator III
Partner - Creator 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) .

    

1 Solution

Accepted Solutions
mjm
Employee
Employee

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

View solution in original post

6 Replies
ogster1974
Partner - Master II
Partner - Master II

D)

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

A) subtracts and D) Ignores

ogster1974
Partner - Master II
Partner - Master II

This document is very useful.

mjm
Employee
Employee

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
Partner - Creator III
Partner - Creator III
Author

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
Partner - Master II
Partner - Master II

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
Partner - Champion III
Partner - Champion III

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