Calculation of subtraction in qlikview for weekly data

[bushpalaamarnat]

Hi

this is my current script which is working.

ICR_Load:

LOAD

Week,

     text(Material) as Material,

     [Material Description],

     [Material Type],

     Category,

     [Demand Volume (Eaches)],

     DFC,

     Brand,

     [Sub-Brand],

     Variant,

     Lifecycle,

     [Customer Loc],

     [Customer Location Description],

     [Customer Zone],

     [Supplier Loc],

     [Min DFC],

     [Max DFC],

     [Safety Days Supply],

     Week & text(Material) & [Customer Loc] as %Key,

     text(Material) & [Customer Loc] as %MasterKey,

ApplyMap('MAP',[Customer Loc],'Not Franchise') as FranchiseMarket,

     if(DFC = 0 and [Demand Volume (Eaches)] < 0,'OOS',

          if(DFC < [Min SFT Days] and [Demand Volume (Eaches)] > 0, 'Low Stock',

          if(DFC >= [Min SFT Days] and DFC <= [Max SFT Days], 'Intolerance',

          if(DFC > [Max SFT Days], 'Overstock',

          if(DFC = 0 and [Demand Volume (Eaches)] = 0, 'NoDemand')))))

FROM

(qvd);

Now the next step to accomplish, i need advise how to do it better. The data sample looks as follows

Week	Material	Loc	DFC
W06-18	1234	USD	4
W06-18	2345	IND	230
W06-18	3456	FR	450
W06-18	1234	UK	36
W07-18	1234	USD	9
W07-18	2345	IND	237
W07-18	3456	FR	455
W07-18	1234	UK	41

Now i need to calculate difference in DFC  of that specific week & material & Loc in a new column.

Regards,

Neelima.

[techvarun]

Share some sample data.

[bushpalaamarnat]

The data sample looks as follows

Week	Material	Loc	DFC
W06-18	1234	USD	4
W06-18	2345	IND	230
W06-18	3456	FR	450
W06-18	1234	UK	36
W07-18	1234	USD	9
W07-18	2345	IND	237
W07-18	3456	FR	455
W07-18	1234	UK	41

[bushpalaamarnat]

DO any one see a solution? kindly help.

[bushpalaamarnat]

If you notice in the image, i am trying to get the difference between that week's materia & loc combination with next weeks for DFC parameter. Could any one assist.