load using string variables problem

[paolojolly]

Hi,

I'm pretty new to Qlikview.

I find a problem if I try to run the following script

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;-€ #.##0,00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='gen;feb;mar;apr;mag;giu;lug;ago;set;ott;nov;dic';

SET DayNames='lun;mar;mer;gio;ven;sab;dom';

LET vID = '009LG';

CC:

Load TEXT($(vID)) AS C_ARTICOLO, DATE(40756+ROWNO()-0-1,'DD/MM/YYYY') as DATA_ANALISI

  AutoGenerate 40791-40756+1;

if I set

LET vID = '00505';

the problem does not occur

Can someone help me?

Thank you very much

[danieloberbilli · Accepted solution]

You need single brackets in your load statement:

CC:

Load TEXT('$(vID)') AS C_ARTICOLO, DATE(40756+ROWNO()-0-1,'DD/MM/YYYY') as DATA_ANALISI

  AutoGenerate 40791-40756+1;

[#3]

hi,

Load '$(vID)' AS C_ARTICOLO, DATE(40756+ROWNO()-0-1,'DD/MM/YYYY') as DATA_ANALISI works

[sujeetsingh]

Try taking chr() function

[sujeetsingh]

Danial yes you are right take the ''

[paolojolly]

thank you very much