topic Re: load using string variables problem in QlikView

load using string variables problem

paolojolly — Wed, 15 Jan 2014 12:03:20 GMT

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 — Wed, 15 Jan 2014 12:09:49 GMT

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;

Wed, 15 Jan 2014 12:11:28 GMT

hi,

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

sujeetsingh — Wed, 15 Jan 2014 12:12:08 GMT

Try taking chr() function

sujeetsingh — Wed, 15 Jan 2014 12:13:51 GMT

Danial yes you are right take the ''

paolojolly — Wed, 15 Jan 2014 13:12:16 GMT

thank you very much