topic Add column to a table in QlikView

Add column to a table

Wed, 28 Nov 2012 08:07:22 GMT

Hi ALL,

How do i create another field of ABC

DATE (datedoftssb,'DD-MM-YY') as ABC

with Month only in the same table without have to reextract all again in another qvw.

As far as i know i need to use this

Month(Date#(ABC, 'DD MMM YYYY')) as Month.

Kindly advice.

Thanks.

Anonymous — Wed, 28 Nov 2012 08:09:17 GMT

You can use:

Month(DATE (datedoftssb,'DD-MM-YY')) as Month,

Wed, 28 Nov 2012 08:14:37 GMT

tq...

Anonymous — Wed, 28 Nov 2012 08:16:01 GMT

You're welcome.

Another option is to use a Preceding Load, like this:

Load

Month(ABC) as Month;

Load

DATE (datedoftssb,'DD-MM-YY') as ABC

FIELD2,

FIELD3,

etc

FROM SOURCE;