Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
Creator
Creator

NEW YEAR REQUIREMENT

Hi all,

I have a requirement where we want to have year from september to august.Can any one tell us how to do?

7 Replies
YoussefBelloum
Champion
Champion

Hi,

you are talking about reload (script) ? or on some analysis (expressions) ??

Anil_Babu_Samineni

What year is that? Perhaps this?

Load *, If(Year = 2017 and (Month >= 'september' and Month <= 'august'), 1,0) as Flag;

Load Year(Date) as Year,

         Date(Month(Date), 'MMMM') as Month

From Table;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
manu1512
Creator
Creator
Author

from script yusuf

manu1512
Creator
Creator
Author

from every year from 1986 to 2050

Anil_Babu_Samineni

You can use where condition to restrict the data like my month condition?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Siva_Sankar
Master II
Master II