topic Re: summing an equation in QlikView

summing an equation

anriretief — Mon, 29 Jan 2018 06:29:53 GMT

I would like to sum the following equation ([VERVOER-TARIEF] + VERVOER)*[FAKTUUR MASSA]/1000

I have tried the regular summing function but it doesn't seem to work

There is also a condition on this sum: [TIPE GRAAN] not equal to 'WITMIELIES'

Can someone please help me with this

Anil_Babu_Samineni — Tue, 30 Jan 2018 00:36:31 GMT

Sum Aggregation only works Numeric not for characteristics. So, You would need this if it is number

RangeSum([VERVOER-TARIEF], VERVOER)*([FAKTUUR MASSA]/1000)

anriretief — Tue, 30 Jan 2018 05:15:42 GMT

Thank you!

It works, I appreciate your help

marcus_sommer — Tue, 30 Jan 2018 11:26:04 GMT

I assume that you need something like this:

sum(aggr(

sum({< [TIPE GRAAN] -={'WITMIELIES'}>} ([VERVOER-TARIEF] + VERVOER)*[FAKTUUR MASSA]/1000),

YourChartDimensions))

whereby the aggr is only needed if you want to display partial sums or totals.

- Marcus

anriretief — Wed, 31 Jan 2018 07:11:59 GMT

THANK YOU!

Anil_Babu_Samineni — Thu, 01 Feb 2018 00:32:44 GMT