Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

Comulative Values

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 ?

1 Solution

Accepted Solutions
sunny_talwar

Try this:

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

View solution in original post

5 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
subbareddykm
Creator II
Creator II
Author

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.

Capture.PNG

sunny_talwar

Try this:

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

View solution in original post

subbareddykm
Creator II
Creator II
Author

HI Sunny,

Its working fine.

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

sunny_talwar