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: 
Anonymous
Not applicable

Previous month from selected month

Good day!

Help please with my task)

How to calculate sales with month, which is previous from selected month?

some like:

sum({<Month=....>}Sales)

Thanks

1 Reply
Anonymous
Not applicable
Author

Depends on your data model

try sum({Month={$(=month(addmonths(yourdate,-1))}...

or sum({Month={$(=Month-1)}--- if Month is numeric