Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lampshadedreams
Contributor III
Contributor III

Shift Field Data by One Month

Hi,

I have the following Expressions in my Chart:

 

Line 1:

=Sum(Budget)

Line 2:

=Sum(Spent)

 

What I would like to do is modify the Spent expression so that it shows for subsequent Month.

 

For example the month of June 2019:  

Line 1 (Shows Budget Amount for June 2019)

Line 2 (Shows Spent Amount for July 2019)

 

To do this I would need to shift the Spent field by one month forward. Is there any way to do this?

1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

Hi,

You can use below function to return the data for the subsequent row, in this case month;

20190731_1.png

Cheers,

Chris.

View solution in original post

3 Replies
chrismarlow
Specialist II
Specialist II

Hi,

You can use below function to return the data for the subsequent row, in this case month;

20190731_1.png

Cheers,

Chris.

lampshadedreams
Contributor III
Contributor III
Author

The Below() function was EXACTLY what I needed! 

I spent days trying to figure this out, thank you so much Chris!

chrismarlow
Specialist II
Specialist II

You are welcome.