topic need help in QlikView

need help

Thu, 19 Feb 2015 18:29:38 GMT

Hello community,

I need a clarification on while loading the data from QVD into qlikview application

a QVD, which consists years of data (2006 - 2012)

While loading the data into qlikview from QVD,here my requirement is load only 3years of data which is from 2010 to 2012 instead of loading all the data from QVD.

In this scenario how can I accomplish my requirement dynamically?

Plz help me out in this.

Re: need help

Thu, 19 Feb 2015 18:35:49 GMT

Simply add a WHERE clause at the end of the LOAD

WHERE(YEAR >= '2010' AND YEAR <= '2012' );

if 2010 and 2012 is dynamically decided during load you can use variables instead of literals

Re: need help

Anonymous — Thu, 19 Feb 2015 18:38:45 GMT

You can load the max(year) from the QVD before it is actually loaded to be able to dynamically pull your data.

MaxYear:

LOAD

max(year) as Year

from myQvd.qvd;

LET vMaxYear = Peek('Year',-1,'MaxYear');

Drop Table MaxYear;

Use that variable then to calculate your rolling years.

Re: need help

Thu, 19 Feb 2015 19:14:41 GMT

Could you please elaborate this again???

Re: need help

maxgro — Thu, 19 Feb 2015 19:17:59 GMT

// test data in qvd (2006-2012)

DIRECTORY;

for i=2006 to 2012

aaaa:

load $(i) as year , rowno() as id AutoGenerate 100;

NEXT;

store aaaa into aaaa.qvd (qvd);

DROP Table aaaa;

// get max year from qvd file and load

t: LOAD max(year) as MaxYear from aaaa.qvd (qvd);

let vMaxYear=Peek('MaxYear')-2;

final: load * from aaaa.qvd (qvd) where year >= $(vMaxYear);

DROP Table t;

Re: need help

Anonymous — Thu, 19 Feb 2015 19:20:51 GMT

Loading the max year will give you a way to work dynamically. If your max year keeps going up, you'll need to adjust based upon that. So say max year is 2012 and you need to go back to 2010 you can say $(vMaxYear) - 2 to give you 2010. So coding this like Erdal did above, you'd want to use this:

WHERE(YEAR >= '$(vMaxYear)-2' AND YEAR <= '$(vMaxYear)' );

Re: need help

Thu, 19 Feb 2015 21:12:14 GMT

thanks for reply

I need one more clarification

To read single qvd into qlikview from the qvd source path(Load * from <qvdpath><qvdname>.qvd(qvd))

But how to read multiple qvds at a time, is it possible???

Pls suggest!!!

Re: need help

Anonymous — Thu, 19 Feb 2015 21:15:16 GMT

You can use the * as a wildcard to load multiple QVD's at once. Ex: OrderData*.qvd will load OrderData2014 and OrderData2015 at the same time.

Load * from <qvdpath>*.qvd(qvd))