topic Re: Get the Current Year In Script in QlikView

Get the Current Year In Script

Anonymous — Thu, 18 Apr 2013 00:30:53 GMT

Hello! maybe this is just a simple problem for a pro like you...

I'm trying to extract the current year (Fiscal_Year) and quarter (Fiscal_Qtr) in my qvd file. I use max(Fiscal_Year) in my where statement but did not work. I also tried using Fiscal_Year =date(now(),'YYYY') but still does not work...

My objective is to get the 1st day and last day of the current year and quarter so I can make a countdown for no of days from the befinning of the current quarter (today() - 1st day of the current year and qtr)...

I really appreciate if you could help me...

Re: Get the Current Year In Script

Gysbert_Wassenaar — Thu, 18 Apr 2013 05:47:59 GMT

You can use daynumberofyear(today()) and daynumberofquarter(today()) to calculate those numbers.

Re: Get the Current Year In Script

Anonymous — Thu, 18 Apr 2013 17:08:08 GMT

Hi! Gesbert,

This one works for regular calendar...But I want to compute based on Fiscal_Calendar... Like the 1st day of Fiscal Year is 09/01/2012....

My QVD file is like this :

Date FiscalQtr Fiscal Year

08/31 /2012 4 2014

9/01/2012 1 2013

12/01/2012 2 2013

hope my requirement is clearer now...

Re: Get the Current Year In Script

Gysbert_Wassenaar — Thu, 18 Apr 2013 17:13:35 GMT

daynumberofyear(addmonths(today(),-4))

daynumberofquarter(addmonths(today(),-4))

Re: Get the Current Year In Script

Anonymous — Fri, 19 Apr 2013 21:24:25 GMT

Gysbert,

This one will work only if the 1st day of quarter is 1...Our Fiscal Calendar varies by date...Our 1st day of the quarter does not necessarily to be 1...like for this quarter, our 1st day is 03/02/2013.