Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
i figured it myself
year(Today())&'-'& 'Q' & CEIL(NUM(MONTH(QuarterStart(today(),-1)))/3)
i figured it myself
year(Today())&'-'& 'Q' & CEIL(NUM(MONTH(QuarterStart(today(),-1)))/3)