topic Qlikview Code help understand in QlikView

Qlikview Code help understand

userid128223 — Tue, 05 Jun 2012 14:42:27 GMT

New to QlikView I always get errors while coding and it is due to field being not recognized. Can someone explain me how qlikviwe works.

Load

date as tempdate,

date(date#(left(tempdate,10),'MM/DD/YYYY')) as newdate

from ......

the above will give me error saying tempdate not recognized, becuase it is within the same Load function. Why does that happen, how can i manipulate a field and make it available right after instead of creating new resident load.

Thanks

Qlikview Code help understand

Tue, 05 Jun 2012 14:49:44 GMT

The "tempdate" field will not exist in the data model until the load statement is complete.

You can try this:

Load date(date#(left(tempdate,10),'MM/DD/YYYY')) as newdate;

Load

date as tempdate,

from ......;

Qlikview Code help understand

userid128223 — Tue, 05 Jun 2012 18:16:04 GMT

i tried that but then it ignores the load statement after and does not load any date from full load statement.

My goal is to load a table with correct date field.

Qlikview Code help understand

Tue, 05 Jun 2012 19:23:12 GMT

Load

date as tempdate,

date(date#(left(tempdate,10),'MM/DD/YYYY')) as newdate

from ......

change to

Load

date as tempdate,

date(date#(left([date],10),'MM/DD/YYYY')) as newdate

from ......

I would use the square brackets to identify date as a field and not a function. Like Enrique said tempdate does not exist until the load statement is complete.

Qlikview Code help understand

Wed, 06 Jun 2012 04:47:48 GMT

Sorry, the load statement should be:

Load date(date#(left(tempdate,10),'MM/DD/YYYY')) as newdate;

SQL Select

date as tempdate //without ","

from Table;