Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Jacob
Contributor III
Contributor III

Current Month plus one

hi all,

i have month filed and i want to show current month plus 1.

example:

i have month May which is current month and i want to show June  .

 

 

Please can any one help.

Labels (4)
2 Replies
sunny_talwar

Show this where in a text box object?

Colin-Albert

Have you looked at the addmonths() function?

addmonths(<your date field>) , 1)    will return the next month based on a date field.

If your data is just the month name and not a date then something like this will work 
month(addmonths(date#('May', 'MMM'), 1))
month(addmonths(date#(<your month field>, 'MMM'), 1))

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...