topic Re: sum function in QlikView

sum function

Thu, 24 Jan 2013 11:50:39 GMT

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 — Thu, 24 Jan 2013 12:19:49 GMT

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

er_mohit — Thu, 24 Jan 2013 12:26:23 GMT

using sum(distinct value)

hic — Thu, 24 Jan 2013 14:39:03 GMT

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

Wed, 30 Jan 2013 14:28:54 GMT

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 — Wed, 30 Jan 2013 16:13:45 GMT

hi try this

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

get rid of sum....