Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Data load

I have YearQtr field in QVD , which stores values like 2014Q1,2014Q2,2014Q3,2014Q4,2015Q1,2015Q2,2015Q3...

I am loading data from the qvd to application,I just want to load data till last quarter in to application from qvd.

like if i am loading data in month of October , November or December 2015 it should load data till 2015Q3 into application even though my qvd have October or November  2015 month data.

2 Replies
MVP
MVP

Re: Data load

Maybe use a WHERE clause like

LOAD * FROM YourQVD.qvd (qvd)

WHERE YearQtr precedes Year(Today(1) &'Q' & Ceil(Month(Today(1))/3);

qvelhoff
Valued Contributor

Re: Data load

I'd create an indicator in your master calendar:

Num(month(QuarterEnd(Today(),-1))) AS PreviousQuarterIND,

Create an INLINE table for a QuarterLimiter:

QuarterLimiter:

LOAD * INLINE [QLimit

1

];

Load the calendar prior to your fact table, then do a where exists(QLimit,PreviousQuarterIND)

Community Browser