Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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