Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
buzzy996
Master II
Master II

how to show this exp in chart level?

hi guys,

Note: x-axis showng as Month dim(like jan,feb,mat..etc)

i have two expression one as openingbalalnce and second as closingbalnce.

i need:- need to show previous month closingbalance as openingbalance for nextmonth with respect to the x-axis dimension(Month)?????

any help???

thx

1 Reply
Anonymous
Not applicable

Not 100% sure what you mean.. but if your closing balance is for example:

Sum(ClosingBalance)

you could use:

Above(Sum(ClosingBalance)) to pull the previous months sum as the value for the second expression.