Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

urgent change : Please remove the two row IT from this list and if possible add a information : like : " For any incident please raise a incident ticket".

This is Script :

Publisher:

LOAD DISTINCT

    max(DATE) AS BOOKING_MONTH_PUBLISHER

FROM

    $(QvdLogisticsFolder)\Date_SourceTable.qvd (qvd)

WHERE DATE = $(CURRENT_MONTH);

// Get last available month with inventory Balance information (2011-10-06)

// this will be used as enddate for loading of Inventory Turns

Inventory_Balance_Max_Date:

LOAD

DISTINCT MAX(INV_BAL_DATE) as MAX_BAL_DATE

FROM  $(QvdFinanceFolder)\Inventory_Balance_SourceTable.qvd (qvd);   

LET LAST_BAL_DATE = Peek('MAX_BAL_DATE',0,Inventory_Balance_Max_Date);

Trace LAST_BAL_DATE  => $(LAST_BAL_DATE);

       

/*---------------------------------------------------------------------------*/

/* INTRO TABLES                                                              */

/*---------------------------------------------------------------------------*/

Intro_Version_Management_Table:

LOAD DISTINCT

  [Version] AS 'Intro Version Management Version'

  , [Date] AS 'Intro Version Management Date'

  , [Description] AS 'Intro Version Management Description'

  , 'qmem://<builtin>/' & [Symbol] AS 'Intro Version Management Image'

FROM

  [$(DataFolder)/EU Logistics Scorecard - Version Management.xls] (biff, embedded labels, table is [Version Management$])

;

Intro_Contacts:

LOAD DISTINCT

  [Pin Number] AS 'Intro Contacts Pin Number'

  , [Full Name] AS 'Intro Contacts Full Name'

  , [Area] AS 'Intro Contacts Area'

  , [eMail] AS 'Intro Contacts eMail'

  , [Phone] AS 'Intro Contacts Phone'

FROM

[$(DataFolder)/EU Logistics Scorecard - Version Management.xls] (biff, embedded labels, table is [Contacts$])

;

/*---------------------------------------------------------------------------*/

1 Reply
Not applicable
Author

Problem is solved