Calculate the amount of expression in all dimensions, except for one of the dimensions

mikhail_sirik — Wed, 05 Oct 2016 07:57:34 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", in all dimensions, except for one of the dimensions. For example, the dimension of "Sex" should be ignored (even if the user has selected). The choice of other dimensions values shall be considered.

Like that:

=sum({$<(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 1200;

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

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

Re: Calculate the amount of expression in all dimensions, except for one of the dimensions

sunny_talwar — Wed, 05 Oct 2016 16:00:29 GMT

May be this:

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

=Sum({$<Sex>} Sale)

topic Re: Calculate the amount of expression in all dimensions, except for one of the dimensions in QlikView

Calculate the amount of expression in all dimensions, except for one of the dimensions

Re: Calculate the amount of expression in all dimensions, except for one of the dimensions