topic Total on straight table in QlikView

Total on straight table

Tue, 08 Feb 2011 13:07:12 GMT

Hello,

In a straight table I have 6 dimensions:

- building

- 5 dimensions of hierarchy product: product 1, product 2 ...

There is no link beetween my expression and the hierarchy of product. So, I want to have the total of the building for every rows.

For example:

Building 1 | Product 1 | Product 2 | Expression

1 | 1 | 1 | 150

1 | 2 | 2 | 150

2 | 3 | 1 | 100

2 | 2 | 1 | 100

...

Can anyone help me?

Total on straight table

Wed, 09 Feb 2011 05:17:10 GMT

Hi,

You can use the TOTAL keyword in your expression to achieve this.

your expression will look like sum(TOTAL <Building> Value)

here Building represents the name of the filed which contains the building dimension and Value represents the name of the field which contains the value for the building.

May be this help you.

Thanks & Best Regards,

Kuldeep Tak