Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for
Did you mean:
Partner - Contributor

## Ignore all dimensions, except for one

Pls, help!

Let me have 20 dimensions (Sex, Year, Country ... etc 20 dimensions). I also have a measure of "Sales". All in a single table.

How do I calculate the amount of expression on the "Sales", ignoring all the dimensions, except for one of the dimensions. For example, the dimension of "Sex" should be considered.

Like that:

=sum({1<(ignore)Sex>} Sale)

 Sales Sex Year Country … 20 100 1 2016 USA 200 2 2016 China 300 1 2016 Russian 100 2 2015 USA 200 1 2015 China 300 1 2015 Russian

Result:

If user choose Sex = 1 then the sum must be equal to 900;

If user choose Sex = 2 and Year = 2016 then the amount should be equal to 300;

If user choose Sex = 1 and Year = 2016 and Country = USA then the amount must be equal to 900;

1 Solution

Accepted Solutions
MVP

May be this:

=Sum({1<Sex = p(Sex)>} Sale)

or

=Sum({1<Sex = \$::Sex>} Sale)

2 Replies
MVP

May be this:

=Sum({1<Sex = p(Sex)>} Sale)

or

=Sum({1<Sex = \$::Sex>} Sale)

MVP

Attaching the sample back with the updated KPI objects

Community Browser