topic Re: Range Sum in QlikView

Range Sum

Anonymous — Tue, 08 Dec 2015 21:59:36 GMT

Hi, every one !

Hi all,
I need help with this expression , my problem is that, is not adding the Promedio , someone has any idea how to solve it.

rangesum(above(sum(if(FPronostico>=FechaPT,Promedio)),0,731))

this is what I want to accomplish for every one column.

Thank you a lot.

roger_stone — Tue, 08 Dec 2015 22:07:18 GMT

Why have you got four identical Promedio columns for a start? I can't see the connection between the first and second screenshots.

Anonymous — Tue, 08 Dec 2015 22:11:14 GMT

Because each representing a week is the field fechaPT is a pivot table, is one expression

roger_stone — Tue, 08 Dec 2015 22:16:04 GMT

I must be missing something here. You're just adding 78,363.33 to each previous day's total?

MarcoWedel — Wed, 09 Dec 2015 00:09:54 GMT

Hi,

can you please post a sample application to test with?

thanks

regards

Marco

Anonymous — Wed, 09 Dec 2015 18:16:32 GMT

Thanks, Marco, I found my mistake.

Sum(Aggr(rangesum(above(if(FPronostico>=FechaPT,Promedio,0),0,Count(FPronostico))),GpoMat,FechaPT,FPronostico))