year function

[#1]

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.

[#2]

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

[parimikittu]

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

[#4]

Thanks for your reply

[#5]

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.

[MindaugasBacius · Accepted solution]

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

Home ‒ QlikView

About the year function:

year ‒ QlikView

[MindaugasBacius]

Besides, do more experiments.

Create new Text Object.

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

[parimikittu]

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.