topic Seting date to day/weeks/month in QlikView

Seting date to day/weeks/month

Fri, 24 Feb 2012 09:25:03 GMT

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

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.

Seting date to day/weeks/month

CELAMBARASAN — Fri, 24 Feb 2012 09:33:15 GMT

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

Seting date to day/weeks/month

Fri, 24 Feb 2012 09:40:56 GMT

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

Seting date to day/weeks/month

CELAMBARASAN — Fri, 24 Feb 2012 09:42:42 GMT

Hi,

For that use

WeekDay function WeekDay(DateField).

Celambarasan

Seting date to day/weeks/month

Fri, 24 Feb 2012 09:50:42 GMT

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

Seting date to day/weeks/month

CELAMBARASAN — Fri, 24 Feb 2012 09:54:11 GMT

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

Seting date to day/weeks/month

perumal_41 — Fri, 24 Feb 2012 10:08:14 GMT

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