qlikviewqliksense

What does "+1" mean in the following Qlik expression


I am assuming the following expression means sum of sales for year 2009 and country Sweden, but I am not sure why +1 is being used, is it used as separator or it has any special meaning?

Sum({$<Year={2009}>+1<Country={'Sweden'}>} Sales)


Solution

  • 1 in set analysis indicates that the calculation will ignore all selections made - returns a full set of data irrespective of user selections

    In your case I can read the calculation like this:

    Give me the union sum of Sales for:

    Helpful links: