Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Contributor

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