Variable Evaluation Problem

Mon, 22 Nov 2010 19:14:15 GMT

Hi guys,

I have declared a variable which does a data conversion. I want to add this variable so that it loads the correct file which has this date appendage at the end, while in a loop.


set


 PrevDateYYMM= right(date(addMonths(MAKEDATE(20&LEFT([Master_Calendar_Month_Key],2),RIGHT([Master_Calendar_Month_Key],2)), -1)), 2) & mid(date(addMonths(MAKEDATE(20&LEFT([Master_Calendar_Month_Key],2),RIGHT([Master_Calendar_Month_Key],2)), -1)), 4, 2);

LOAD

'$(PrevDateYYMM)'

 TEAM

FROM [REPORT_$(PrevDateYYMM)];

The problem is with this is that it does not evaluate the variable. If I create a field in the script with the same code I get the correct figures but I have to compute this in the script to load the correct files as I am also doing a loop. What it is not doing is giving an error saying cannot load REPORT_$right(date(addMonths(MAKEDATE(20&LEFT([Master_Calendar_Month.......(full expression).

I've tried using both let and set but neither are giving me the answer i want. Has anyone any ideas as the method to create the value is correct, it just uses the expression and not the computed value in the script.

Thanks,

Variable Evaluation Problem

vgutkovsky — Mon, 22 Nov 2010 20:43:49 GMT

Put the word LET in front of the variable declaration instead of SET 🙂

Regards,

Variable Evaluation Problem

Tue, 23 Nov 2010 09:56:19 GMT

Thanks Vlad,

Had used LET previously - just realised the problem I had was i was referencing the wrong field when doing so, d'oh! 🙂

Thanks again

topic Variable Evaluation Problem in QlikView

Variable Evaluation Problem

Variable Evaluation Problem

Variable Evaluation Problem