topic Re: year function in QlikView

year function

Wed, 25 Nov 2020 16:16:04 GMT

Hai Friends,

I want to know about year function and one of my instruction in the script is like this

%year >= (Year(Today())-2)
and %month<=12
and %month>=1

could you please explain the above statement , how it works

can any one you please help me.

Re: year function

Mon, 09 Jan 2017 10:11:59 GMT

Hi Supriya,

As for my knowledge

==> %year >= (Year(Today())-2)

1.today() is a date function is display today date like 09-01-2017

2.year() is get the year of 09-01-2017 means 2017

3.next 2017-2=2015

Re: year function

parimikittu — Mon, 09 Jan 2017 10:22:02 GMT

Hi, Is this logic is used to generate financial yr calendar? Can you please provide the complete if statement.

Re: year function

Mon, 09 Jan 2017 10:25:24 GMT

Thanks for your reply

Re: year function

Mon, 09 Jan 2017 10:30:29 GMT

Hai sir,

Thanks for your reply

Actually these instructions are under where condition

The issue is ,data not populating in the dashboard for 2017 year.

Re: year function

MindaugasBacius — Mon, 09 Jan 2017 10:31:06 GMT

I sincerely suggest you to put this link into your favorites:

Home ‒ QlikView

About the year function:

year ‒ QlikView

Re: year function

MindaugasBacius — Mon, 09 Jan 2017 10:34:57 GMT

Besides, do more experiments.

Create new Text Object.

Try the same Text Object but with different Text (Expression) like =Year(Today()).

Re: year function

parimikittu — Mon, 09 Jan 2017 11:06:11 GMT

the where condition says load everything where year greater than or equal to 2015 and month in range of 1 to 12. Check the value of %year and %month where there are having correct values or not.