# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Contributor III

## Set analysis disregarding dimension

Hi Qlikers,

I found that with set Analysis I can use expresison below to sum my sales disregarding selections but not dimension. Is it possible to also disregard dimension? What is the syntax?

sum ({1} Sales) :Returns total sales for the app, disregarding selections but not the dimension

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set-analysis...

In fact I found a way doing: sum(ALL(Sales)). But I would like some of my selections to interact on my chart so I did this with set analysis

sum({1<[Country]=P([Country])>}Sales).

But then in my chart that has [Import Date] on x-axis it will not sum ALL for each value of my dimension [Import Date] .

So how to sum ALL and specify for some dimension that I want to be able to interact with my chart?

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: Set analysis disregarding dimension

sum({1<[Country]=p(), City = p() >}TOTAL Sales)

7 Replies
MVP

## Re: Set analysis disregarding dimension

May be you need this?

Sum({1<[Country] = \$::[Country]>}Sales)

MVP

## Re: Set analysis disregarding dimension

Or maybe you need to additionally use the TOTAL qualifier (maybe with a field list)?

Sum({1<[Country] = \$::[Country]>} TOTAL Sales)

The Aggregation Scope

Esteemed Contributor

## Re: Set analysis disregarding dimension

Hi Sunny, what does this do ? = \$::[Country] ; It's first time seeing such an expression !

Contributor III

## Re: Set analysis disregarding dimension

Hi,

Thanks for your quick response. So in fact I only needed to add TOTAL but at the right place:

sum({1<[Country]=P([Country])>}TOTAL Sales). This one works. If I put \$:: instead of P the expression is not working as Qlik Sense doesn't reconize this syntax.

Last Question: if I want several fields to interact, like Country and City, what would be the syntax?

MVP

## Re: Set analysis disregarding dimension

sum({1<[Country]=p(), City = p() >}TOTAL Sales)

Contributor III

## Re: Set analysis disregarding dimension

Great !!

New Contributor III

## Re: Set analysis disregarding dimension

Hi Stefan,

Need a small help

Community Browser