# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Contributor II

## ignoring dimensions into expression

Dear all,

is it possible to ignore the dimension into a calculated expression ?

What I'm trying is this:

Year Month   Customer     Sales          %

2012  10          AAA          1500          12

...

The % is calculated as   sales/total sales for year and month, ignoring the customer dimension

Sales represents the total sales per customer, on October 2012. Year and Month are selected values by list boxes. The dimension is CUSTOMER

Any help is reallu appreciated

Thanks in advance for your help

1 Solution

Accepted Solutions
Honored Contributor

## Re: ignoring dimensions into expression

If you have a chart with dimensions Year, Month and Customer and an expression like sum(Sales), you can use sum(total <Customer> Sales) to sum the sales across the whole range of customers.

3 Replies
Honored Contributor

## Re: ignoring dimensions into expression

If you have a chart with dimensions Year, Month and Customer and an expression like sum(Sales), you can use sum(total <Customer> Sales) to sum the sales across the whole range of customers.

MVP & Luminary

## Re: ignoring dimensions into expression

Hi,

Use TOTAL to ignore the dimensions.

=Sum(TOTAL<Dim1, Dim2, ....> Sales) in this experssion only the Dim1, Dim2... are considered.

=Sum(Sales) / Sum(TOTAL<Dim1, Dim2, ....> Sales)

Regards,

Jagan.

Contributor II

## Re: ignoring dimensions into expression

Thanks very much!!