Discussion Board for collaboration on QlikView Scripting.
I have a stored proc which I want to run for 2 specific dates... which date is a parameter.
currently im doing something like
Let date = today();
Let prevDate = AddMonths(Today(),-1);
LOAD *;SQL EXEC (DWH.dbo.gb_FI_CustomersStarRating $('date'));
for some reason it is not executing it...it just jumps it.
Help will be appriciated
I think you will need to remove the ' from round the variable. This is an example of a stored procedure call we use :
sql exec dbo.usp_gls215_build_report_v2 $(ThisYear)
Very kind and helpful
Actually here is what I did and it worked!
Let Date = date(today(),'yyyy/MM/dd');
Let prevDate = date(AddMonths(Today(),-1),'yyyy/MM/dd');
LOAD *;SQL EXEC DWH.dbo.gb_FI_CustomersStarRating '$(Date)';