topic Re: ignoring dimensions into expression in QlikView

ignoring dimensions into expression

Anonymous — Tue, 27 Nov 2012 08:37:48 GMT

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

Re: ignoring dimensions into expression

Anonymous — Tue, 27 Nov 2012 08:40:17 GMT

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.

Re: ignoring dimensions into expression

jagan — Tue, 27 Nov 2012 13:00:09 GMT

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.

Re: ignoring dimensions into expression

Anonymous — Sun, 02 Dec 2012 10:18:49 GMT

Thanks very much!!