Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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.

View solution in original post

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.