sum function

[#1]

Hi,

I've an issue with the value column on my report.

The first line should be 17,433 - which is showing the value of in Area 2001

The second line however should read 74.50

I'm using the function - sum(TotalValue) but this is obviously using the total value and applying it to each colunm.

Whats the best way to have the appropriate Value being shown for each line/Area?

Thanks

[sivarajs]

Try using aggr function.Something like sum(aggr(sum(value),product,Area)

[er_mohit]

using sum(distinct value)

[hic]

I suspect you use

     Sum( Total Value )

when you should use

     Sum( Value )

The "Total" is a keyword that makes QlikView display the total of the chart. Not the line.

HIC

[#5]

Im basically linking 2 tables together,

Table A                    Table B

-Material                    -Material

-Total Value               -Area

                                 -Volume

The 'Volume' figure is correct as there are a number of Materials in different Areas

However, when I join the tables, the Total Value distinguish which Area the Material comes from, and thus gives me an incorrect figure.

Hope this makes sense!

[shree909]

hi try this

instead of uisng sum  use in the expression as  total value-->field name

get rid of sum....