topic total calculation in QlikView

total calculation

Anonymous — Tue, 07 Feb 2012 10:51:30 GMT

hi folks,

how cani achieve 100+400+200+300

object is straight table

dim : country

country revenue

1 100

2 200

3 300

4 400

kaushiknsolanki — Tue, 07 Feb 2012 11:09:52 GMT

Hi,

All you have to do is just Go to properties of straight table -> Expression -> Click on Expression -> Total Mode -> Select Expression Total.

If you want a new column as overall total then you can add expression as Sum(Total revenue)

Regards,

Kaushik Solanki

swuehl — Tue, 07 Feb 2012 11:10:29 GMT

Have you tried just creating a chart with dimension country and an aggregation function as expression:

=sum(revenue)

check Total mode: Expression total in expression tab is enabled (or sum of rows, depending on your needs and data model).

Hope this helps,

Stefan