Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Creator III
Creator III

Previous Day Value as Today's Balance Qlik sense Script

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.

Labels (4)
1 Solution

Accepted Solutions
sunny_talwar

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;

 

View solution in original post

5 Replies
sunny_talwar

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

UserID2626
Creator III
Creator III
Author

I want to do in Script

sunny_talwar

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
Creator III
Creator III
Author

Thank you   .

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...