Aggregation over only one dimension.

Thu, 06 Aug 2009 18:21:27 GMT

Hi.

I would like to know if it is possible get a formula affected only on selections of one field.

i.e.

I´ve a table INVOICES with several fields (Dates, Customers, Amounts, Salesreps ...) in one sheet I have a list field on CUSTOMER with all of posible customers on invoices.

Is it possible create a text field with the sum INVOICES.AMOUNT for all the selected CUSTOMERS but without considering the rest of the selections.

With this data.

INVOICE,CUSTOMER,MONTH,AMOUNT

INV-1, CUST-1, JAN, 1000

INV-2, CUST-2, FEB, 2000

INV-3, CUST-1, MAR, 3000

INV-4, CUST-4, APR, 4000

The total amount would be:

Without selections = 10.000 (All of the invoices)

If JAN is selected = 10.000 (All of the invoices , there is not selections on CUSTOMER)

If select CUST-1 = 4000 (INV-1 + INV-3 are the invoices for CUST-1)

If select CUST-1 and JAN = 4000 (INV-1 + INV-3 are the invoices for CUST-1 without considering MONTH)

Regards

Aggregation over only one dimension.

Thu, 06 Aug 2009 18:36:58 GMT

Here you go!

Rainer

Aggregation over only one dimension.

Thu, 06 Aug 2009 18:47:56 GMT

Thanks Rainer.

But there is a problem. This is a summary of the total data.

Really I could have many other dimensions, and there is not possible to add all of them to the formula.

I attach your document with other dimension.

topic Aggregation over only one dimension. in QlikView

Aggregation over only one dimension.

Aggregation over only one dimension.

Aggregation over only one dimension.