Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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?