topic Dollar sign expansion in loading script not working in QlikView

Dollar sign expansion in loading script not working

dt_g_tsar — Fri, 27 Jul 2012 10:38:04 GMT

Hello All,

It seems I have come across a rather strange behaviour which I cannot explain.

I have been using EXECUTE and TRACE statements in my loading script for quite a while and in several cases I have been using variables in there to formulate the string. The way I am doing that is by using the usual dollar sign expansion to grab the value in the variable. I have now come across a specific EXECUTE string where the variable does not evaluate but it just shows as $(numPage), effetively breaking my execute statement.

Are there any specific string conditions where dollar sign expansion would not work?

Thank you,

George

Re: Dollar sign expansion in loading script not working

jonathandienst — Fri, 27 Jul 2012 10:39:49 GMT

Please post the script (at least the offending portion)

Regards

Jonathan

Re: Dollar sign expansion in loading script not working

dt_g_tsar — Fri, 27 Jul 2012 10:44:32 GMT

Here is the script for what I am trying to do...

___________________________________________

Let numPage = 1;

FOR i=0 to 5

EXECUTE curl/curl.exe -u api-customer@customer.com/token:sometoken https://customer.zendesk.com/api/v2/tickets.json?page=$(numPage) -k -o ..\QVD\Zendesk\tickets$(numPage).json;

let numPage = ($(numPage) + 1);

trace $(numPage);

next i;

___________________________________________________________________

So I would expect $(numPage) to be resolved correctly in my string as it usually does but it does not unfortunately.