topic Re: Group dates by month in QlikView

Group dates by month

Tue, 07 Aug 2012 14:05:05 GMT

I have a ton of dates over the last calendar year that I would like to group by month for a line chart I'm developing. Is there a way to do this?

Re: Group dates by month

Tue, 07 Aug 2012 14:06:39 GMT

In your load script add Month(Date) or Date(Date,'MMM')

Re: Group dates by month

Tue, 07 Aug 2012 15:13:04 GMT

I'm not sure how to do this. I've included my load script below. The date I want to change is Chg Service Date. Can you please tell me where I add the Month(Date)?

LOAD [Chg Tx ID],

[Patient Name],

MRN,

[Unique MRNs],

[MRN + Month+FY],

[Unique MRN/Month],

DOB,

[Chg Service Date],

FY,

[MRN/FY],

[Unique MRN/FY],

Month,

[Month/Type/FY],

[Chg Post Date],

[Current Payor Name],

[Current Plan Name],

Type,

Department,

Specialty,

[POS Type],

POS,

[Guarantor Name],

[Patient Country],

[Patient Country Name],

CPT,

[CPT Desc],

Vol,

[Chg Amt],

Pmts,

[Projected Pmts],

[Total Adj],

[Bal Due]

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD [Hospital Account ID],

[Patient Name],

[Admission Date],

[Discharge Date],

[Length of Stay(LOS)],

[Patient Mrn],

[Primary Payor Name],

[Current Plan Name],

[Chg Service Date],

FY,

[Tx Post Date],

[Procedure Code (CPT/HPCS)],

[Procedure Desc],

[Transaction Quantity],

[Chg Amt],

Trans_Base_Class,

[Ub Rev Code ID],

[Patient Country Name]

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Group dates by month

rajni_batra — Wed, 08 Aug 2012 06:18:34 GMT

LOAD [Chg Tx ID],

[Patient Name],

MRN,

[Unique MRNs],

[MRN + Month+FY],

[Unique MRN/Month],

DOB,

[Chg Service Date],

month([Chg Service Date]) as [Chg Service Month]

FY,

[MRN/FY],

[Unique MRN/FY],

Month,

[Month/Type/FY],

[Chg Post Date],

[Current Payor Name],

[Current Plan Name],

Type,

Department,

Specialty,

[POS Type],

POS,

[Guarantor Name],

[Patient Country],

[Patient Country Name],

CPT,

[CPT Desc],

Vol,

[Chg Amt],

Pmts,

[Projected Pmts],

[Total Adj],

[Bal Due]

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD [Hospital Account ID],

[Patient Name],

[Admission Date],

[Discharge Date],

[Length of Stay(LOS)],

[Patient Mrn],

[Primary Payor Name],

[Current Plan Name],

[Chg Service Date],

month([Chg Service Date]) as [Chg Service Month]

FY,

[Tx Post Date],

[Procedure Code (CPT/HPCS)],

[Procedure Desc],

[Transaction Quantity],

[Chg Amt],

Trans_Base_Class,

[Ub Rev Code ID],

[Patient Country Name]

FROM

(ooxml, embedded labels, table is Sheet1);

It will return you month of date respective date in the same manner YEAR can be calculated

Hope it helps!!!