Below is few examples of a field that has rolling quarter. These values are derived from a date column (YYYYMM format).
How to achieve the result as seen below in a chart? It's always 4 rolling quarters. Minstring and Maxstring doesn't always give correct result.
Result = 1Q 2017
Result = 2Q 2017
Result = 3Q 2017
Result = 1Q 2018
Solved! Go to Solution.
If you use Max() then ??
May be assign this field an underlying numeric value...
LOAD Dual(Pick(WildMatch(QuarterYear, '1Q*', '2Q*', '3Q*', '4Q*'), 3, 6, 9, 12) + Right(QuarterYear, 4), QuarterYear) as QuarterYear
and now max and maxstring will both work
Hi Andrew and Sunny,
Thank you for your response. I tried both the option but didn't seem to work.
I attached a sample QVW. Basically, I need to get the latest value of the rolling quarter - either in YYYYMM format or <Qtr_Num>Q YYYY (for instance 1Q 2017).
Any ideas, please?