Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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);

NickHoff
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)