Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

Button for Current Quarter/Year

I have a filed called Quarter Year and I need to create a button using the action toggle select. I need the button to select the current quarter-year.

The field I am selecting from is called "QuarterYear" and is formatted like

Q1-16

Q2-16

Q3-16

Q4-16

Q1-17

Since today is 01-13-2017 the button should toggle select Q1-17.

thanks in advance

1 Solution

Accepted Solutions

Re: Button for Current Quarter/Year

May be like this

Field

QuarterYear

SearchString

'Q' & Ceil(Month(Today())/3) & '-' & Date(Today(), 'YY')

View solution in original post

3 Replies
MVP
MVP

Re: Button for Current Quarter/Year

Like this?

Re: Button for Current Quarter/Year

May be like this

Field

QuarterYear

SearchString

'Q' & Ceil(Month(Today())/3) & '-' & Date(Today(), 'YY')

View solution in original post

Partner
Partner

Re: Button for Current Quarter/Year

Perfect. Thanks