topic Re: How to get Qtr_n ? in QlikView

How to get Qtr_n ?

paulyeo11 — Sat, 18 Apr 2020 03:03:09 GMT

Hi All

My below 2 expression work fine :-

(year(today()) - year([TempDate])) * 12 + month(today()) - month([TempDate]) + 1 as Month_n,
year(today()) - year([TempDate]) + 1 as Year_n,

May i know how to get Qtr_n ?

year(today()) - dual('Q' & ceil(Month(TempDate)/3) & '-' & right(year(TempDate),2),quarterstart(TempDate)) as Qtr_n1,

it return very large value , which is wrong.

Paul

Re: How to get Qtr_n ?

Vegar — Sat, 18 Apr 2020 17:09:23 GMT

Maybe something like this:

(Month(QuarterStart(today()))-Month(QuarterStart([TempDate])))/3+(Year(today())-Year([TempDate]))*4 as Quarte_n

Re: How to get Qtr_n ?

Brett_Bleess — Thu, 14 May 2020 19:53:13 GMT

Paul, if Vegar's suggest worked, we would appreciate it if you can be sure to return to the thread and use the Accept as Solution button on his post to close the thread, which will give Vegar credit for the assistance and let other Members know that did work for you.

The only other thing I can offer is the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/Year-over-Year-Comparisons/ba-p/1462927

Regards,
Brett

Re: How to get Qtr_n ?

paulyeo11 — Thu, 14 May 2020 22:55:28 GMT

Hi All

Thank you for your help it work now.

Paul