topic Re: Extra Row with Sum in QlikView

Extra Row with Sum

mariozubieta — Mon, 08 Jan 2018 22:56:13 GMT

Hello,

I was wondering if anyone know a possible solution for an issue I'm having.

Basically, what I have is a Number of Events for every month on a table.

Like:

I need a way, inscript that I can add an extra row with the sum(Events) of the current and previous 2 months.

The desired result would be:

Thanks for the help.

devarasu07 — Mon, 08 Jan 2018 23:18:02 GMT

Hi,

Try with asofTable method at back end script

for front end expression u can try like below

rangesum( above( sum(Events),0,12) )

sum( aggr( rangesum( above( sum( {$<TimeKey>} Events),0,12) ),TimeKey))

uacg0009 — Tue, 09 Jan 2018 07:50:15 GMT

Hi Mario,

Hope the attachment is what you want.

Thanks.

Aiolos