topic Variable in script loading empty in QlikView

Variable in script loading empty

stjernvd — Tue, 15 Dec 2015 19:01:49 GMT

Hi,

I have a set a variable name for my table in the script and for some reason it is loading blank, why?

Set $(table) = Product_Regions_$(vM);

TRACE 'tbl : $(table)';

(vM = peek('Months',-1, 'Months))

What I get in my loader is:

'tbl: '

I don't see what I am doing wrong.

MK_QSL — Tue, 15 Dec 2015 19:08:27 GMT

Set table = Product_Regions_$(vM);

What is vM?

stjernvd — Tue, 15 Dec 2015 19:12:11 GMT

I see my error, silly me, thank you!!

Anonymous — Tue, 15 Dec 2015 19:12:42 GMT

Looks like you have a stray single quote :

(vM = peek('Months',-1, 'Months))

Hard to see even when I made it bold red. It is before the second Months.