Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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?