previous yearquarter from today()

stonecold111 — Sat, 16 Nov 2024 03:24:54 GMT

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??

Re: previous yearquarter from today()

stonecold111 — Sat, 01 Jun 2019 07:23:03 GMT

i figured it myself

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