topic Script help!!! in QlikView

Script help!!!

amit_saini — Mon, 24 Aug 2015 11:56:30 GMT

Hi Folks ,

I'm having 6 qvds as below:

latencytime_inst1.qvd

latencytime_inst2.qvd

latencytime_inst3.qvd

Responetime_inst1.qvd

Responetime_inst2.qvd

Responetime_inst3.qvd

and across all these qvd's I'm having below table (Columns name are same )----> We can make this as cross table

I have to create a table chart like above , but based on filters below:

Please suggest how this could be possible.

Thanks,

Re: Script help!!!

jonathandienst — Mon, 24 Aug 2015 12:06:27 GMT

Like this, perhaps:

Set vPath = ..... path to your qvd files ....;

For Each vName in 'latencytime_', 'Responetime_'

For Each vFile in FileList(vPath & '\' & vName & '*.qvd')

T_Results:

CrossTable(Location, Value)

LOAD *

FROM [$(vFile)] (qvd);

Results:

LOAD *,

SubField('$(vFile)', '\', -1) As SourceFile

Resident T_Results;

DROP Table T_Results;

The final Results table will have these fields: STDATE, Location, Value, SourceFile

Re: Script help!!!

tresB — Mon, 24 Aug 2015 12:07:25 GMT

Try like:

Load

SubField(FileBaseName(), '_',1) as Filter1,

SubField(FileBaseName(), '_',2) as Filter2

From <> ;

Re: Script help!!!

amit_saini — Mon, 24 Aug 2015 12:20:06 GMT

Hi Jonathan,

Thanks , but below are my qvd's

But after loading the script source file is showing me 2 qvds , it should show all qvds in list box. Please suggest why???

Thanks,

Re: Script help!!!

amit_saini — Mon, 24 Aug 2015 12:27:17 GMT

Below is script:

Set vPath = D:\qvdev\PLM\Latency Report\#Source\Qvd;

For Each vName in 'latencytime_*', 'responsetime_*'

For Each vFile in FileList(vPath & '\' & vName & '*.qvd')

T_Results:

CrossTable(Location, Value)

LOAD *

FROM [$(vFile)] (qvd);

Results:

LOAD *,

SubField('$(vFile)', '\', -1) As SourceFile

Resident T_Results;

DROP Table T_Results;

Re: Script help!!!

amit_saini — Tue, 25 Aug 2015 04:06:33 GMT

any suggestions????

Re: Script help!!!

amit_saini — Tue, 25 Aug 2015 04:16:28 GMT

I Tried this :

Set vPath = D:\qvdev\PLM\Latency Report\#Source\Qvd;

For Each vName in 'latencytime_inst1_8080', 'latencytime_inst2_8070','latencytime_inst3_8060','responsetime_inst1_8080','responsetime_inst2_8070','responsetime_inst3_8060';

For Each vFile in FileList(vPath & '\' & vName & '.qvd')

This is working fine .

Thanks,