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: 
helen_pip
Creator III
Creator III

How to achieve the next month

Hello

I have 3 months worth of data

Apr 2013

May 2013

Jun 2013

I have a button where I can show the current month: =Date(monthstart(AddMonths(min( breach_test),+0)), 'MM-YYYY')

I now want to be able to show the "Next month" in a button and so far I have written: =Date(monthstart(AddMonths(min(breach_test),+1) ), 'MM-YYYY')

However with the "Next Month" button,the user will be able to click on it twice as it will show May 2013 on the first click and then Jun 2013 on the 2nd click.

How do I get the next month button to just show I.e. May 2013 data

Any help would be greatly appreciated

Thanks

Helen

0 Replies