topic Re: making dates in QlikView

making dates

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi,

In my Master Calendar I have

Year(TempDate) As Year

This displays as :-

but when I create a variable for Current Year it displays like this?:-

why does vYear_Current not show as a year?

Re: making dates

avinashelite — Wed, 28 Sep 2016 06:37:19 GMT

what is the expression your using for defining for the vYear_Current ??

Re: making dates

susovan — Wed, 28 Sep 2016 06:46:10 GMT

Try this,

=Date(Your Variable,'YYYY')

Re: making dates

Anonymous — Wed, 28 Sep 2016 06:49:05 GMT

LET vYear_Current = Year(Today());

Re: making dates

Anil_Babu_Samineni — Wed, 28 Sep 2016 06:55:48 GMT

Laura, The reason is that LET expression. Try to take text object and then try

=$(vYear_Current)

='$(vYear_Current)'

OR in script

Load TempDate, Year(TempDate) as vYear_Current Inline [

TempDate

01-01-2000];

Re: making dates

florentina_doga — Wed, 28 Sep 2016 07:01:32 GMT

use year(vYear_Current)

Re: making dates

Anonymous — Wed, 28 Sep 2016 07:10:58 GMT

I tried all three with no luck

Re: making dates

Anil_Babu_Samineni — Wed, 28 Sep 2016 07:13:51 GMT

Hahaha, Would you share the application. For me it's working good.

Re: making dates

qlikview979 — Wed, 28 Sep 2016 07:21:42 GMT

Hi Try this May be

LET vYear_Current = right(Year(Today()),4)

Re: making dates

Anonymous — Wed, 28 Sep 2016 07:39:09 GMT

the reason for me wanting to use current year is so that when it comes to month end, I can revert back to last month for month End Reports. i.e. this is a data sample . I simply count all leads for the Week;Month;Year. I need the CurrentMonth Variable for year to be '2015'

Re: making dates

jonathandienst — Wed, 28 Sep 2016 07:42:08 GMT

Your expression for the variable is correct, so there is no need to change anything there. The values of vYear_current in the list box were not produced by that expression as they are dates, whereas the expression returns just the year number.

There is some confusion though - you cannot show a variable (which has a single value) in a list box. So it seems you have a variable vYear_current AND a field named vYear_current and the list box is displaying the field values. There is no relationship between the variable vYear_current and the field vYear_current.