Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

hopkinsc
Valued Contributor II

using specific dates in script?

Hi, i currently have a 10 week transaction application which looks at a rolling 10 weeks.

The expression i have used in my script is :

CapperCalender:

    LOAD Cal_Year,

         Cal_Period,

        Cal_Week,

         Cal_YearDay,

         Cal_Date AS TradingDate,

         [Cal_Year-Period]

    

    FROM $(cFileName) (qvd) WHERE Date(Cal_Date) >= Date(Today() -70);

This will only load in data dated todays date going back 70 days.

I want it to show from the date 22/08/11 going back 56 days.

Can anyne help?

Thanks

1 Solution

Accepted Solutions
MVP
MVP

using specific dates in script?

try maybe

WHERE Date(Cal_Date) >= Date(makedate(2011,08,22) -56) and Date(Cal_Date) <= Date(makedate(2011,08,22));

Regards,

Stefan

1 Reply
MVP
MVP

using specific dates in script?

try maybe

WHERE Date(Cal_Date) >= Date(makedate(2011,08,22) -56) and Date(Cal_Date) <= Date(makedate(2011,08,22));

Regards,

Stefan