Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Partner - Creator III
Partner - 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
Partner - Creator III
Partner - 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
Partner - Creator III
Partner - 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...