Query regarding Expression

[nikhilgarg]

1 : According to me following Expression should return Sum of all the sales excluding the current selection with Company Name 'A'.

2:  But it is return somewhere that it will return Company 'A' Sales excluding current selection.

=Sum({1 - $<Company_Name = {'A'}>} Sales)

Where Company_Name is a Field

Is option 1 correct or 2 correct and if 2 is correct den why? Please clear my doubt.

[nikhilgarg]

Hey mike  ,

There is no Script Functions mentioned  after navigating to script syntax

[Michael_Tarallo]

Try this:

https://help.qlik.com/sense/en-US/online/index.html

On the left look for:

Working with Qlik Sense

      -> Loading Data

             ->Script Syntax

                  -> Script Functions

[nikhilgarg]

HEy Mike ,

Thanx a lot... this will really help me understanding different functions use as i am a beginner in qlikview.