# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
Contributor II

## How to compare the value in the next column in straight table?

Hello All,

I have data like below -

 Sprint Work Days Planned Commited Points Output 1 Day 0 0 60 60 1 Day 1 8 60 52 1 Day 2 8 60 44 1 Day 3 4 60 40 1 Day 4 6 60 34 1 Day 5 5 60 29 1 Day 6 4 60 25 1 Day 7 6 60 19 1 Day 8 10 60 9 1 Day 9 4 60 5 1 Day 10 5 60 0

Output Column Calculation : For Days 0, Committed Points - Planned = 60 - 0 = 60,

For Days 1 , Output Column first value(60) needs to be compared with second row of planned (8) -> 60 - 8 = 52.

For days 2 Output Column second value (52) needs to be compared with third row of planned (8) -> 52 - 8 = 44.

How to achieve the values that are showing in the output column in Qlikview?

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: How to compare the value in the next column in straight table?

maybe (chart with Work Days and Sprint as dimensions)

sum([Commited Points])

- rangesum(Above( total sum(Planned), 0, RowNo(TOTAL)))

2 Replies
MVP

## Re: How to compare the value in the next column in straight table?

maybe (chart with Work Days and Sprint as dimensions)

sum([Commited Points])

- rangesum(Above( total sum(Planned), 0, RowNo(TOTAL)))

Contributor II

Thanks a lot !!

Nisha