Ignore all dimensions, except for one

mikhail_sirik — Thu, 06 Oct 2016 05:39:46 GMT

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;

Re: Ignore all dimensions, except for one

sunny_talwar — Thu, 06 Oct 2016 16:08:08 GMT

May be this:

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

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

Re: Ignore all dimensions, except for one

sunny_talwar — Thu, 06 Oct 2016 16:41:15 GMT

Attaching the sample back with the updated KPI objects

topic Re: Ignore all dimensions, except for one in QlikView

Ignore all dimensions, except for one

Re: Ignore all dimensions, except for one

Re: Ignore all dimensions, except for one