topic Re: Inline Date in QlikView

Inline Date

VishalWaghole — Tue, 09 Jul 2013 12:45:34 GMT

Hi QV Developer,

How to Load Inline date????

Please if anyone know then guide to me.

Thanks.

alexandros17 — Tue, 09 Jul 2013 12:48:25 GMT

AAA:

LOAD * Inline

[
myDate

05/12/1998

];

BBB:

NoConcatenate

LOAD

year(myDate) as myYear

Resident AAA;

DROP Table AAA;

orital81 — Tue, 09 Jul 2013 12:53:40 GMT

Attached an example

VishalWaghole — Tue, 09 Jul 2013 12:59:16 GMT

Thanks for reply.

But i dnt want to hardcod date in Inline table.

Is it possible to declare any variable and that will return todays date.

VishalWaghole — Tue, 09 Jul 2013 12:59:26 GMT

Thanks for reply.

But i dnt want to hardcod date in Inline table.

Is it possible to declare any variable and that will return todays date.

alexandros17 — Tue, 09 Jul 2013 13:02:17 GMT

You can use Today() or Now() functions

Tue, 09 Jul 2013 13:44:55 GMT

try using

LOAD * Inline

[
myDate

today()
];