Discussion board where members can get started with QlikView.
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
Since today is 01-13-2017 the button should toggle select Q1-17.
thanks in advance
Go to Solution.
May be like this
'Q' & Ceil(Month(Today())/3) & '-' & Date(Today(), 'YY')
View solution in original post