Qlikview Help

[#1]

Dear All,

I want to help in Qlikview.

1) The excel Auto Save in a Folder every day and qlikview every day load the excel file.

2) 20140325AAL it is my excel. how i insert 2014= Year, 03= Month, 25= day, than AAL= Factory Name= AAL Auto Create in Qlikview.

[anbu1984]

You missed "filebasename() as FileNm" in your load statement created from excel. Check my script above

[its_anandrjs · Accepted solution]

Actually load this way and for auto reload and creation you have to use the QV publisher and from there schedule the Qlikview app and reload on that time. And let me know from the excel file you want to read the Year,Month,Day and factory name if so then use this script

LOAD

SL,

[Type of Bill],

Remarks,

Left(Filebasename(),4) as Year,

Mid(Filebasename(),5,2) as Month,

Mid(Filebasename(),7,2) as Day,

Right(Subfield(Filebasename(),'_',1),3) as Factoryname,

FileBaseName() as Name

FROM

[..\20140325AAL.xls]

(biff, embedded labels, table is [20140325AAL$], filters(

Remove(Row, Pos(Top, 1))

));

And You get

Regards

Anand

[#4]

Thank's I solved this problem.

but every day my come 30 xlsx file by mail.

so, every day i don't possible it's save a folder than load qlikview and

coding script.

so how i save a folder than qlikview automatic load the file than auto

script and auto update.

Thnak's

Ala Uddin Asif

Bangladesh

On Fri, Oct 31, 2014 at 12:59 PM, Anand Chouhan <qcwebmaster@qlikview.com>