Seting date to day/weeks/month

[#1]

Hello,

im trying to change my dates to day, week or month format. Ive got a list called "date" and there is a list like

15.11.2011

15.11.2011

15.11.2011

15.11.2011

16.11.2011

16.11.2011

16.11.2011

These are dates of tickets. I want to get a graph who shows this dates as day and just count them that i can see the number of tickets by day.

Hope you can help me.

[CELAMBARASAN]

Hi,

     Use

          Day(DateField) as Dimension and Count(DateField) as expression

     If qlikview didn't recognized this as date then use Date#(DateField,'DD.MM.YYYY') or make set this variable as this format

     SET DateFormat='DD.MM.YYYY';

Hope it helps

Celambarasan

[#3]

ty, but i already got this. Just need to show the date like 15.11.2011 as day - Monday.

[CELAMBARASAN]

Hi,

     For that use

     WeekDay function WeekDay(DateField).

Celambarasan

[#5]

ah and how and where do i insert this ? need i set every date to this manual ? ive got a big list inserted from excel

[CELAMBARASAN]

Hi,

     While loading excel you need to do this.

     Load

          *,

          DateField,

          WeekDay(DateField) as WeekDay

     From Excel file;

     Then use this weekday field as dimension.

Celambarasan

[perumal_41 · Accepted solution]

Hi,

Possible to two way

One Way insert in Load Statement

Load *,weekday(Datefield),week(Datefield),month(datefield)

from filename.xls

other Way use directly in Expression

Sum(if(week(Datefield)=32,Amount))

Regards

Perumal A