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

Change Values of a field

how to change the values​​ of a field month for the previous month?

4 Replies
Nicole-Smith

AddMonths(YourField, -1)

Not applicable
Author

works only when I select a list, I want to use it in a PivotTable field itself as a dimension month, when I do this, I put in a variable and then in setanalise, it overrides

swuehl
MVP
MVP

Try with chart inter record functions like above() and before(), e.g.

=before(sum(Amount))

or

=above(sum(Amount))

Nicole-Smith

Can you post an example?