Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stored procedure queries

Is this the porper syntax



maxYrDate:

Directory



...\marketing_sales_data;



load

max(Y1) as maxYr from sales.qvd (qvd)

;

let

maxSalesYr = peek('maxYr')

;

maxMoDate:

Directory



...\marketing_sales_data;



load

max(M1) as maxMo from sales.qvd (qvd) where Y1=$(maxSalesYr)

;

let

maxSalesMo = peek('maxMo')

;

maxDayDate:

Directory

...\marketing_sales_data;

load

max(D1) as maxDay from sales.qvd (qvd) where Y1=$(maxSalesYr) and M1=$(maxSalesMo)

;

let

maxSalesD = peek('maxDay')

;



sales:

SQL

Execute dbo.SelectIncrementalSales $(maxSalesYr), $(maxSalesMo), $(maxSalesD);

Directory

... \marketing_sales_data;

//Concatenate Load * from sales.qvd (ansi, txt, delimiter is ',', embedded labels);

Concatenate Load * from sales.qvd (qvd);

Directory

... \marketing_sales_data;

store

sales into sales.qvd;





for incremental data load because the stored procedure doesn't seem to run. In the debug, the program just seems to skip over it.

thanks

kevin

1 Reply
Not applicable
Author

stored procedure:

SelectIncrementalSales

@maxSalesYr

as int

,

@maxSalesMo

as int

,

@maxSalesD

as int