topic Re: How to display Current Qtr ? in QlikView

How to display Current Qtr ?

paulyeo11 — Sat, 18 Apr 2020 18:53:47 GMT

Hi All

Below working fine for Display Current Month :-
=Date(AddMonths(today(), -1),'MMM YY')

Below working for display Current Year :-
='S$K' & Chr(10) & date(date#(Year(Today())-0,'YYYY'),'YY') /* Year(Today())

I try to Get Current Qtr using below :-

=Right(year(TempDate),2) & '-Q' & ceil(Month(TempDate)/3)

I dont know how to start.

Paul

Re: How to display Current Qtr ?

Yousef_Amarneh — Sun, 19 Apr 2020 08:03:49 GMT

Try the below

=Right(year(TempDate),2) & '-Q' & ceil(Num(Month(TempDate))/3)

Re: How to display Current Qtr ?

paulyeo11 — Sun, 19 Apr 2020 08:11:48 GMT

Hi Sir

Thank you for your sharing .
Your expression when I place at expression label , it does not display correct info. Also you can use the field name = TempDate , as this expression not place at load script.

Paul

Re: How to display Current Qtr ?

Yousef_Amarneh — Sun, 19 Apr 2020 08:54:15 GMT

The expression that I mentioned should be used on the script, however, if you want to get the current quarter in the dashboard use the below

Right(year(Today()),2) & '-Q' & ceil(Num(Month(Today()))/3)

it will give you 20-Q2

Re: How to display Current Qtr ?

paulyeo11 — Mon, 20 Apr 2020 01:39:48 GMT

Hi Sir

Thank you very much , I try to modify your script to get 19Q4 , I am unable to get it . Look like Quarter is very tricky.

Paul