topic Re: How to get year dynamically? in QlikView

How to get year dynamically?

madhubabum — Thu, 07 Jan 2016 08:17:24 GMT

Hi Experts

I am having the following issue,Here i am having the following variables

LET vStartYear=2013;

LET vCurrentYear=year(today());

LET vMinDate=01-01($(vCurrentYear) - $(vStartYear));

OutPut: -3

But, How we can get 01-01-2013 dynamically

Thanks

Madhu

Re: How to get year dynamically?

Chanty4u — Thu, 07 Jan 2016 08:19:22 GMT

hi madhu,

https://community.qlik.com/message/666977#666977

chk abve link

Re: How to get year dynamically?

jonathandienst — Thu, 07 Jan 2016 08:24:12 GMT

Use:

Let vMinDate = MakeDate(vStartYear, Month(Today()), Day(Today()));

Re: How to get year dynamically?

tresB — Thu, 07 Jan 2016 08:24:48 GMT

may be like:

Let vMinDate=YearStart(Today(), -3) ;

Re: How to get year dynamically?

Thu, 07 Jan 2016 08:34:00 GMT

=date#(YearStart(Today(), -3) ,'dd-mm-yyyy')

Re: How to get year dynamically?

madhubabum — Thu, 07 Jan 2016 08:47:47 GMT

Hi Jonathan dienst,

Thank you very much for your reply.

Here i am getting output like : 1/7/2013 (as mentioned above code)

But, I want as following format 01-01-2013.

How , we can achieve.

Re: How to get year dynamically?

Chanty4u — Thu, 07 Jan 2016 08:53:51 GMT

date(ur datefield,' mm-dd-yyyy') as year

Re: How to get year dynamically?

tamilarasu — Thu, 07 Jan 2016 09:04:19 GMT

Try,

Let vMinDate= Date(YearStart(Today(), -3) ,'DD-MM-YYYY')

Re: How to get year dynamically?

Peter_Cammaert — Thu, 07 Jan 2016 09:38:43 GMT

Storing a date as a number or as a text value in a variable (variables, because of being an MS VBScript object, cannot store dual values) both have advantages in specific cases.

you want to use vMinDate in calculations or to control script executing, store it as a number. Calculations will be done on numerical values anyway
you want to use vMinDate to display a loaded/calculated date in a text on a sheet, store it as a string.

When using a date in a variable in a situation where the format does not correspond to the required format, conversions must be done. You can avoid these by choosing the best storage type in advance.

In the end, it doesn't really matter much for QlikView because you can always convert from one format to the other. But it means more work for both you and the QV engine(s).

Best,

Peter