topic Re: Qlikview Help in QlikView

Qlikview Help

Fri, 31 Oct 2014 06:10:19 GMT

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.

Re: Qlikview Help

AbhijitBansode — Fri, 31 Oct 2014 06:26:18 GMT

Use Subfield(filebasename(),'_',1) as Source to get whole filename. then you can string functions on it get desired fields. Like :

Left(Subfield(Filebasename(),'_',1),4) as Year

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

and on...

Re: Qlikview Help

its_anandrjs — Fri, 31 Oct 2014 06:30:15 GMT

In excel sheet you want to insert the 2014= Year, 03= Month, 25= day, than AAL= Factory Name= AAL, Or in the Qlikview you want.

Regards

Anand

Re: Qlikview Help

Fri, 31 Oct 2014 06:44:40 GMT

Thank's please sent a example.

Re: Qlikview Help

Fri, 31 Oct 2014 06:49:53 GMT

Thank's Please sent a example.

Re: Qlikview Help

anbu1984 — Fri, 31 Oct 2014 06:52:07 GMT

Load *,Left(FileNm,4) as Year,Mid(FileNm,5,2) as Month,Mid(FileNm,7,2) as Day,PurgeChar(FileNm,'0123456789') As FactoryNm;

LOAD Factory,

AAL,

F3,

filebasename() as FileNm

FROM

[20140325AAL.xls]

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

Re: Qlikview Help

its_anandrjs — Fri, 31 Oct 2014 06:58:10 GMT

Try this below load script and but let me know from excel sheet you want to read to the Qlikview

LOAD Factory,

AAL,

Left(Filebasename(),4) as Year,

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

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

Right(Filebasename(),3) as Factoryname,

FileBaseName() as Name

FROM

[20140325AAL.xls]

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

Regards

Anand

Re: Qlikview Help

Fri, 31 Oct 2014 07:01:34 GMT

Thank's for your nicely cooperation but I am extremely sorry for your

valuable time wastage.

I want to Qlikview auto load the excel file every day 3:00Pm and auto

create date every day and auto create factory.

On Fri, Oct 31, 2014 at 12:53 PM, anbu cheliyan <qcwebmaster@qlikview.com>

Re: Qlikview Help

Fri, 31 Oct 2014 07:02:10 GMT

See the attatchment

Re: Qlikview Help

Fri, 31 Oct 2014 07:02:47 GMT

Hii

Field:20140325AAL

Left(field,4) as year

mid(field,5,2) as month

mid(field,7,2) as day

right(field,3) as Factory Name

Re: Qlikview Help

anbu1984 — Fri, 31 Oct 2014 07:12:21 GMT

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

Re: Qlikview Help

its_anandrjs — Fri, 31 Oct 2014 07:16:21 GMT

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

Re: Qlikview Help

Fri, 31 Oct 2014 09:59:10 GMT

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>