Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nishaloganathan
Creator II
Creator II

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

Hello All,

I have data like below -

    

SprintWork DaysPlannedCommited PointsOutput
1Day 006060
1Day 186052
1Day 286044
1Day 346040
1Day 466034
1Day 556029
1Day 646025
1Day 766019
1Day 810609
1Day 94605
1Day 105600

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?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

maybe (chart with Work Days and Sprint as dimensions)

sum([Commited Points])

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

1.png

View solution in original post

2 Replies
maxgro
MVP
MVP

maybe (chart with Work Days and Sprint as dimensions)

sum([Commited Points])

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

1.png

View solution in original post

nishaloganathan
Creator II
Creator II
Author

Thanks a lot !!

Nisha