Previous Day Value as Today's Balance Qlik sense Script

[UserID2626]

Hi,

I need to show Opening & Closing , i.e, Yesterday Closing Value is today opening. 

Date	Opening	Closing
9-Dec-19	250	200
10-Dec-19	200	135
11-Dec-19	135	111
12-Dec-19	111	10

Help me with script to load opening & Closing as two measures.

[sunny_talwar]

You want to do this in the script or front end of the application?

[UserID2626]

I want to do in Script

[sunny_talwar · Accepted solution]

May be just Join Like this

Table:
LOAD Date,
     Value as Opening
FROM ....;

Left Join (Table)
LOAD Date - 1 as Date,
     Opening as CLosing
Resident Table;

[UserID2626]

Thank you  Sunny_talwar .

Its Working

Is it possible to achieve in Set expression also?

[sunny_talwar]

Do you mean set analysis? Set analysis only works on the front end of the application...