topic Re: edit an expression in table by month in QlikView

edit an expression in table by month

aminehaddar — Wed, 25 Nov 2020 16:16:04 GMT

Hello the community,

I have this table:

The problem is that these number are incremental by month.

I need to have this result:

...

Anyone can help please?

Regards

YoussefBelloum — Wed, 28 Feb 2018 14:22:20 GMT

Hi,

try this:

=sum([sum(valeur)/3])- RangeSum(Above([sum(valeur)/3]),RowNo())

sunny_talwar — Wed, 28 Feb 2018 14:22:53 GMT

In the script or front end?

aminehaddar — Wed, 28 Feb 2018 14:24:29 GMT

I got this:

Any suggestion?

aminehaddar — Wed, 28 Feb 2018 14:25:18 GMT

frond end bro,

in the expression section

YoussefBelloum — Wed, 28 Feb 2018 14:25:27 GMT

here is my QVW

sunny_talwar — Wed, 28 Feb 2018 14:27:42 GMT

I think the expression should be this

=RangeSum(Sum([sum(valeur)/3]), -Above([sum(valeur)/3]))

or this

=RangeSum(Sum([sum(valeur)/3]), -Above(TOTAL [sum(valeur)/3]))

aminehaddar — Wed, 28 Feb 2018 14:45:00 GMT

Thanks bro

YoussefBelloum — Wed, 28 Feb 2018 14:47:11 GMT

haha Sunny we had already faced the same problem.. I'm not gonna ask you why we Should use this or the other