I’m not sure how to modify the load script in Qlikview and I was told that to group dates by month, I have to add Month(Date) to the load script. I loaded in two files and I need the Chg Service Date to show as a month on both files. Can anyone provide assistance?
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);
.png "Luminary Alumni"){kind=icon}