Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nishaloganathan
Contributor 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?

Tags (1)
1 Solution

Accepted Solutions
MVP
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)))

1.png

2 Replies
MVP
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)))

1.png

Highlighted
nishaloganathan
Contributor II

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

Thanks a lot !!

Nisha