topic Re: Current Month and Next Month Buttons in QlikView

Current Month and Next Month Buttons

helen_pip — Tue, 16 Apr 2013 13:31:45 GMT

Hello

I have trawled the internet and have tried various different techniques, but nothing seems to work so far

I have 3 months worth of data

Apr 2013

May 2013

Jun 2013

I want to have a button which shows all data for the current month (I have acheived this by) =Date(monthstart(AddMonths(min(breach_test),0)), 'MM-YYYY')

I can also achieve a button to show the next month with the following criteria: =Date(monthstart(AddMonths(min(breach_test),+1) ), 'MM-YYYY')

However I cannot seem to toggle between the 2 buttons.......The Next month button will keep going into Jun 2013. I want the user to choose between the 2 buttons, without having to go through the entire sequence

Any ideas?

Thanks

Helen

Re: Current Month and Next Month Buttons

Gysbert_Wassenaar — Tue, 16 Apr 2013 16:55:14 GMT

Try using min({1}breach_test) instead of min(breach_test), at least for the Current Month expression. You'll have to decide if you want to use it for the other expression too.

Re: Current Month and Next Month Buttons

helen_pip — Thu, 18 Apr 2013 08:02:24 GMT

Hello

Thank you! This works for me