topic Re: Get Month in QlikView

Get Month

Tue, 20 Aug 2013 13:44:54 GMT

Hi,

I would like to get the Month. I have attached an exemple file it ends in April but it would go on.

So I have sheets with the month and in each sheet all Dates (like 01.02.2013) and no I would like to have a Listbox where I can mark January. Has someone an solution?

Re: Get Month

swuehl — Tue, 20 Aug 2013 13:47:40 GMT

Use the Month() function:

LOAD Datum,

Value,

Month(Datum) as Monat

FROM

(biff, embedded labels, table is [$(vSheet)]);

edit: Or if you want to use your variable:

LOAD Datum,

Value,

'$(vSheet)' as Monat

FROM

(biff, embedded labels, table is [$(vSheet)]);

Re: Get Month

Tue, 20 Aug 2013 13:49:10 GMT

Just create a new field in the script this way:

Month(Date(Datum)) as Month