topic Re: Splitting the Date list box into Month and Year in QlikView

Splitting the Date list box into Month and Year

rt_new_user — Mon, 20 Apr 2015 02:38:04 GMT

Hello Fellow QV users

Can i ask for your help in splitting my Date list box into two other list boxes i.e Year and Month retaining the Date list box as is?

my script so far looks like this:

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LOAD Date,

[VXD1#1 Messages],

[VXD1#1 Requests],

[VXD1#1 Answers],

[VXD1#2 Messages],

[VXD1#2 Requests],

[VXD1#2 Answers],

[NND1 #1 Messages],

[NND1 #1 Requests],

[NND1 #1 Answers],

[NND1 #2 Messages],

[NND1 #2 Requests],

[NND1 #2 Answers],

[Daily Peak] as Total,

FROM

(ooxml, embedded labels, table is [TPS Data]);

ziadm — Mon, 20 Apr 2015 02:46:03 GMT

Hi Ravi

If i got you right you want to have the Month and Year of the Date Field loaded.

if this is the case use the Month & Year Functions

Load Date,

Month(Date) as Month,

Year(Date) as Year;

or you may use it as expression in your Table as having a new expression with Month(Date) and Year(Date)

Regards

Ziad

jagan — Mon, 20 Apr 2015 02:59:00 GMT

Hi,

Try like this

LOAD

Month(Date) AS Month,

Year(Date) AS Year

FROM DataSource;

Regards,

Jagan.