Access excel file from sharing

noman212 — Fri, 04 Jul 2014 06:13:09 GMT

Hi All

i have a sharing folder which contain excels file i want to reload from sharing any idea??

Re: Access excel file from sharing

Fri, 04 Jul 2014 06:18:46 GMT

Hi Noman,

It should not make any difference. Load it as a normal file.

Re: Access excel file from sharing

noman212 — Fri, 04 Jul 2014 06:29:31 GMT

i have the following script

How can i pick file from sharing pc?

For each ExcelFile in filelist ('*.xls')

EOM_HISTORY:

Load

EMP.CODE ,

NAME as EmployeeName,

DESIGNATION ,

[D A T E] as Date,

//TO_DATE as CalendarDate,

Day([D A T E]) AS CalendarDayOfMonth,

WeekDay([D A T E]) AS CalendarDayName,

Week([D A T E]) AS CalendarWeekOfYear,

Month([D A T E]) AS CalendarMonthName,

'Q' & Ceil(Month([D A T E])/3) AS CalendarQuarter,

Year([D A T E]) AS CalendarYear,

// Calendar TO_DATE Names

WeekName([D A T E]) as CalendarWeekNumberAndYear,

MonthName([D A T E]) as CalendarMonthAndYear,

QuarterName([D A T E]) as CalendarQuarterMonthsAndYear,

// Start TO_DATEs

DayStart([D A T E]) as CalendarDayStart,

WeekStart([D A T E]) as CalendarWeekStart,

MonthStart([D A T E]) as CalendarMonthStart,

QuarterStart([D A T E]) as CalendarQuarterStart,

YearStart([D A T E]) as CalendarYearStart,

// End TO_DATEs

DayEnd([D A T E]) as CalendarDayEnd,

WeekEnd([D A T E]) as CalendarWeekEnd,

MonthEnd([D A T E]) as CalendarMonthEnd,

QuarterEnd([D A T E]) as CalendarQuarterEnd,

YearEnd([D A T E]) as CalendarYearEnd,

Time(Time#(Num(Hour([T ME IN]),'00')&Num(Minute([T ME IN]),'00')&Num(Second([T ME IN]),'00'), 'hhmmss')) as Time,

ENT.TYPE as status

From $(ExcelFile) (biff, embedded labels, table is [rptCUMTIMESHEETAll.rpt$], filters(Remove(Row, RowCnd(CellValue, 1, StrCnd(equal, 'Information Systems')))))

WHERE WildMatch(EMP.CODE,'1','2','3','4','5','67','7','8','9','10','11','12','13','14','15','16')and Time(Time#(Num(Hour([T ME IN]),'00')&Num(Minute([T ME IN]),'00')&Num(Second([T ME IN]),'00'), 'hhmmss')) <= '11:00:00';

Next ExcelFile;

Re: Access excel file from sharing

Fri, 04 Jul 2014 06:35:26 GMT

There must be a variable named ExcelFile, where the path must hav been saved. Change the path there.

Re: Access excel file from sharing

engishfaque — Fri, 04 Jul 2014 06:44:52 GMT

Dear Noman,

Problem solved, please find attached screenshot.

Kind regards,

Ishfaque Ahmed

topic Re: Access excel file from sharing in QlikView

Access excel file from sharing

Re: Access excel file from sharing

Re: Access excel file from sharing

Re: Access excel file from sharing

Re: Access excel file from sharing