Load the Rolling 1 year records in Qlikview script.

[Anonymous]

Hi All,

I want to load the rolling 1 year record in qlikview script dynamically. Can anyone assist me.

If script running now (04/28/2017) means, the script should load all the records between (04/28/2016 to 04/28/2017).

If script running  on (04/28/2017) means ,the script should load all the records between (04/29/2016 to 04/29/2017).

Regards,

ShakilaD

[Anil_Babu_Samineni · Accepted solution]

Two conditions are same. I am assuming may be typo error

Here, you can write like below

If Today() Then

Load * From <Data Source> where DateField >= Today() and DateField <= AddYears(Today(), 1)

Else

Load * From <Data Source>

End If

[Anonymous]

Thanks Anil, its working.

[Anil_Babu_Samineni]

Awesome, Can you close this thread by flag of Correct Answer

Qlik Community Tip: Marking Replies as Correct or Helpful