Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

pandiarajan
Not applicable

Prevous value based different Column


Dear all,

     i want to reduce stock value based on previous location and Item

Find Below My Input Data :

LocationItemLineIDDaysReqAvailable
XXXABCLine146132
XXXABCLine240132
YYYABCLine35516
YYYABCLine44316
YYYABCLine54016
YYYABCLine63416
YYYABCLine72316
YYYABCLine8516
YYYABCLine9316

I want this Output

LocationItemLineIDDaysReqAvailableoutput
XXXABCLine14613231
XXXABCLine24013230
YYYABCLine355165
YYYABCLine443164
YYYABCLine540163
YYYABCLine634162
YYYABCLine723161
YYYABCLine85160
YYYABCLine9316-1
Tags (1)