You might be having more than one instance of OrderID in your application, right? Chart is looking at Distinct values of the combination of your dimension/s, whereas the script looks at each and every record unless you tell it otherwise. To get make this work in the script, you will have to take a resident load of distinct OrderID to to do....
LOAD DISTINCT OrderID,
Previous(OrderID) as Test2
Order By OrderID;
Yes that is correct, I do have more than one OrderID intance. I have already tried creating a resident load and I just tried it again unsuccessfully.
I tried this :
I'll attach the excel file maybe you can provide me some insight.
Thank you sunny, I do appreciate your help.
QlikSenseWorkshop - 2.0.xlsx 236.3 K
I guess it needs to be a three step process
[..\..\Downloads\QlikSenseWorkshop - 2.0.xlsx]
(ooxml, embedded labels, table is Orders);
LOAD Distinct OrderID
Previous(OrderID) as OrderCode
DROP Table NewTable;
Tested the script in QlikView, but don't see any issue why it shouldn't work with Qlik Sense.