Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jeckstein
Partner - Creator
Partner - Creator

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
sunny_talwar

May be like this

Field

QuarterYear

SearchString

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

View solution in original post

3 Replies
MK_QSL
MVP
MVP

Like this?

sunny_talwar

May be like this

Field

QuarterYear

SearchString

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

jeckstein
Partner - Creator
Partner - Creator
Author

Perfect. Thanks