topic SyntaxError: FROM is missing in Qlik Learning Discussions

SyntaxError: FROM is missing

Wed, 12 Nov 2014 20:19:01 GMT

Hi everybody,

I am new to QlikView and I hope that you can help me. The code looks like:

Temp:

Load * Inline [

01.01.2014 13:00

02.01.2014 14:00

...

];

let test = date#(peek('F1', 1, Temp)); // it peeks the first date and turns it in other format ('numbers') !!hopefully

testtable:

load 1 + $(test) as Test

Autogenerate(5);

The debugger tells that everything is ok untill load in testtable: here appears SYNTAX ERROR : FROM IS MISSED/ wrong: testtable....

What can I do to make it work?

Thanks in advance for your help

hic — Thu, 13 Nov 2014 09:29:36 GMT

You have several problems here...

You need to quote the table label inside the Peek(): Peek('F1', 1, 'Temp')
If you want the date of the first record, you should use 0 instead: Peek('F1', 0, 'Temp')
If you want the variable 'test' to be displayed as a numeric, you should wrap the expression in Num(...): Num(Date#(...))
The dollar expansion $(test) might expand the variable using decimal comma, which will cause an error. The simplest solution is to quote the dollar expansion: 1 + '$(test)' as Test

HIC

Sat, 15 Nov 2014 12:15:48 GMT

Thank you for the help! It works!