topic Creating multiple QVD files based on a SQL Query in QlikView

Creating multiple QVD files based on a SQL Query

Marcio_Campestrini — Mon, 17 Feb 2014 11:38:17 GMT

Hi!

I have a SQL query that brings a field called "Year" with multiple values (for example, 2012, 2013, 2014). I would to generate various QVD files, one for each year. Does anyone have any examples of how to do this?

Thanks in advance!!

Re: Creating multiple QVD files based on a SQL Query

luis_pimentel — Mon, 17 Feb 2014 11:42:35 GMT

Try something like:

FOR vYear=2012 TO 2014

TempTable:

LOAD * FROM yourtable WHERE Year = vYear;

STORE TempTable INTO '$(vYear)'.qvd (qvd);

NEXT;

Update: Not sure if in the WHERE clausule you nedd Year = vYear or Year = $(vYear)