topic Re: Comulative Values in QlikView

Comulative Values

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

HI All , I

I m calculating values over Id and month , it is giving me correct result but i make any selection in month the same values are not coming same .

For example in my attached file, first dont select any month and see the value for every ID wise (For Jan )and select Jan month and Check the value ,

Not showing the same values.

Can any one tell me how to get this ?

Re: Comulative Values

Gysbert_Wassenaar — Wed, 14 Dec 2016 09:29:55 GMT

Try this one: sum(aggr(rangesum(above(total sum({<Month=>}Value),0,RowNo(total))),Month,ID))

Re: Comulative Values

subbareddykm — Wed, 14 Dec 2016 09:57:25 GMT

Hi ,

Thank you so much for ur responce,

In this expression , its giving me correct as per the data, But If the ID are not same for every month, then in that case its not giving me correct values.

Re: Comulative Values

sunny_talwar — Wed, 14 Dec 2016 10:06:41 GMT

Try this:

RangeSum(Above(TOTAL Sum({<Month>}Value), 0, RowNo(TOTAL))) * Avg(1)

Re: Comulative Values

subbareddykm — Wed, 14 Dec 2016 10:16:45 GMT

HI Sunny,

Its working fine.

Can u explain me , why we used here * avg (1)

Re: Comulative Values

sunny_talwar — Wed, 14 Dec 2016 10:18:25 GMT

Check out my explanation about Avg(1) here:

Re: Chart Funcationality: How can I ignore evaluation of second dimension (for an expression)?