Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Max of Previous Buckets

Hi,

I have scenario where in have to take the Max of the Previous Buckets calculated in each row for a particular ID i.e LAN No

Lan Bukect No (Expected Calculated Value)

1 0 0

1 4 4

1 1 4

2 0 0

2 7 7

2 3 7

I hope somebody could give me a solution for my problem? The topic is complicated but maybe there exists a solution?

Thanks

Kind regards,

Arun

3 Replies
Not applicable
Author

Hi Arun,

Here you are a possible solution. I can't attach an example file because there is a time out error in the server, so, I have to write the expression.


= rangemax([Bukect No], above(sum([Bukect No])))


Watch out with the order of the data, it's very important.

I hope it helps you.

Regards.

Not applicable
Author

Hi Arun,

Here you are a possible solution. I can't attach an example file because there is a time out error in the server, so, I have to write the expression.


= rangemax([Bukect No], above(sum([Bukect No])))


Watch out with the order of the data, it's very important.

I hope it helps you.

Not applicable
Author

Hi,

Thanks for the solution.

Thanks & Regards,

Arun