Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Pivot table to show last work week dates

I have a pivot table and have been using it in my other apps, but for this specific one, I had to make an inline table with a few types of errors. The table I am working on is the Error Type History sheet. If I have Date_Doc_Rv as a column, it shows all dates. I just need each day for the previous week. Any ideas? Below is my script, attached is my file.

//This is where to add new holiday hours

SET vHolidays = '1/2/2017', '5/29/2017', '7/4/2017', '11/23/2017', '11/24/2017', '12/25/2017', '12/26/2017',

'1/1/2018', '5/28/2018', '7/4/2018', '11/22/2018', '11/23/2018', '12/24/2018', '12/25/2018'

                ;

//Days in Month

Let vDiM = NetWorkDays(MonthStart(Max(Date)), MonthEnd(Max(Date)), $(vHolidays));


LOAD

    Date_DOC_Rv,

    Month(Date_DOC_Rv) as Month_RV,

    Num(Month(Date_DOC_Rv)) as MonthNum_RV,

    Year(Date_DOC_Rv) as Year_RV,

    MakeDate(year(Date_DOC_Rv)) as vCY_RV,

    MakeDate(month(Date_DOC_Rv)) as vCM_RV,

    User_DOC_Rv,

    Area_DOC_RV,

    Reviewed_DOC_RV,

    Errors_DOC_RV,

    Miss_Sig_Date_DOC_RV,

    Inc_Data_DOC_RV,

    Other_DOC_RV,

    Write_illeg_DOC_RV,

    Miss_Paper_DOC_RV,

    Copy_DOC_RV,

    Blank_DOC_RV

FROM [lib://qlikid_nathanguyse/DailyTracker.xlsx]

(ooxml, embedded labels, table is DailyTracker);


Type:

Load * Inline [

Type

Miss_Sig

Blank

Incorrect

Missing

Writeover

Other

];

0 Replies