Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
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
jsn
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
jsn
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
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.

bibopipo
Contributor II

Re: ignoring dimensions into expression

Thanks very much!!

Community Browser