Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe something like this:
(Month(QuarterStart(today()))-Month(QuarterStart([TempDate])))/3+(Year(today())-Year([TempDate]))*4 as Quarte_n
Maybe something like this:
(Month(QuarterStart(today()))-Month(QuarterStart([TempDate])))/3+(Year(today())-Year([TempDate]))*4 as Quarte_n
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
Hi All
Thank you for your help it work now.
Paul