Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have a field like quarter with values like 2018Q1,2018Q2,2018Q3,2018Q4,2019Q1
so whenever i open the dashboard i need to see latest two quarters as selected.
how to achive this?
output: 2018Q4,2019Q1 [ if 2019Q2 in the data the result will be 2019Q1 and 2019Q2] like dynamic latest two quarters
Thanks
='(' & year(today()) & 'Q' & ceil(month(today())/3) '|' & year(ADDMONTHS(today(),-3)) & 'Q' & ceil(month(ADDMONTHS(today(),-3))/3) & ')'
garbage error
My bad
='(' & year(today()) & 'Q' & ceil(month(today())/3) & '|' & year(ADDMONTHS(today(),-3)) & 'Q' & ceil(month(ADDMONTHS(today(),-3))/3) & ')'
What about this
=chr(39) & '(' & year(today()) & 'Q' & ceil(month(today())/3) & '|' & year(ADDMONTHS(today(),-3)) & 'Q' & ceil(month(ADDMONTHS(today(),-3))/3) & ')' & chr(39)
@soniasweety wrote:
No luck 😞 still its taking only 2018Q4
assume that i have data 2018Q1 ,2018Q2,2018Q3,2018Q4 ......... the result 2018Q3,2018Q4
Hey ,,, you said latest quarter so it should select 2018q4 AND 2019 Q1
If you need max quarter and second max quarter you have to use maximum expression i have asked you to use
See.. there are two cases
maximum and second maximum quarter use
'(' & MaxString({<string=-{"$(=maxstring(string))"}>}string) & '|' & maxstring(string) & ')'
latest and second latest quarter
'(' & year(today()) & 'Q' & ceil(month(today())/3) & '|' & year(ADDMONTHS(today(),-3)) & 'Q' & ceil(month(ADDMONTHS(today(),-3))/3) & ')'
edit: replace string with your quarter field in first expression
Hi
Did you solve this . if yes then please close the thread.
If not then i am attaching the sample QVW as you have asked, I didn't have qv with me when you asked for a sample. Attached sample is using the expression i have asked you to use.
Thanks
Pradosh