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: 
kamielrajaram
Creator III
Creator III

Previous month sales

Hi all,

Please assist with generating straight table like below. 

I need to show the previous month value In line with the month end . Any suggestions. 

Month end     current month                  previous month
31/03/2019    25.91
30/04/2019    2 6.63                                        2 5.91
31/05/2019    2 .87                                          2 6.63
30/06/2019    224.15                                      2 .87
31/07/2019    271.29                                      224.15 

Thank you

Regards

Kamiel

1 Solution

Accepted Solutions
kamielrajaram
Creator III
Creator III
Author

Hi Sunny,

Thank you. I managed to do this in the script.

Kind Regards

Kamiel

View solution in original post

3 Replies
kamielrajaram
Creator III
Creator III
Author

Hi all,

Apologies,I thought it was resolved by using the above function.  But when I select a specific month end date I lose the value for the previous month. This has not been resolved.

 

Thank you

sunny_talwar

Try something like this

Above(Sum({<Month, MonthEnd, Date>}Sales)) * Avg(1)

Be sure to add all the date and time fields where you might make a selection. 

kamielrajaram
Creator III
Creator III
Author

Hi Sunny,

Thank you. I managed to do this in the script.

Kind Regards

Kamiel