previous yearquarter from today()

[stonecold111]

Hi Qlikss,

I want 2 values in text object1) current yearquarter 2) previous yearquarter .

i know how to calculate current yearquarter:   = year(Today())&'-'& 'Q' & CEIL(NUM(MONTH(Today()))/3)

how can i calculate previous quarteryear??

[stonecold111 · Accepted solution]

i figured it myself

year(Today())&'-'& 'Q' & CEIL(NUM(MONTH(QuarterStart(today(),-1)))/3)