Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Increment Field based on another field value and factor

Dear Friends,

I have a table with multiple Id's. the % field has some null values. So the value in these % null fields has to be inserted. in such a way that the next value is  ( difference between the upper and lower value , divided by days diff+1 ) .

I have been able to calculate the days as  diff 1.    

Problem Table:                                                                                                                                                                                

IDStartDateNQ%AddFactorDiff 1Diff 2RowNo
707/22/201407.415X11
707/23/201412
707/24/201414.8316.6713
707/25/201414
707/26/201448.1715.7125
707/27/201426
707/28/20147
707/29/201495.3X8

                                                                                                                          

Required Table : (required values are color coded in red)

IDStartDateNQ%AddFactorDiff 1Diff 2RowNo
707/22/201407.415X11
707/23/20140+7.41512
707/24/201414.8316.6713
707/25/201414.83+16.6714
707/26/201448.1715.7125
707/27/201448.17+15.7126
707/28/201448.17+15.7+15.717
707/29/201495.3X8

Attached is the file for detail info.Please help.

Thanks,

Gizzel