topic Re: Current Month plus one in QlikView

Current Month plus one

Jacob — Sat, 16 Nov 2024 03:25:56 GMT

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.

Re: Current Month plus one

sunny_talwar — Wed, 29 May 2019 23:04:30 GMT

Show this where in a text box object?

Re: Current Month plus one

Colin-Albert — Thu, 30 May 2019 11:05:12 GMT

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/DateAndTimeFunctions/addmonths.htm