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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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