How can we analysis the LOG file of QVW application

[Anonymous]

Hi friends,

help on how we can analysis the qlikview application log file,currently i am working for optimization of qvw application in there i have to check in script where it's taking max time.

please help me .

thanks for advance.

Thanks

SHAIK

[#2]

You can use the Governance Dashboard or the System Monitor or load the logs into QlikView and build your own Analysis.

[sandeepprasad_j]

Hello Shaik,

Please find the below link

Using the QlikView Trace Function | Get Business Intelligence Software

Hope this helps ...

Thnaks,

Sandeep.

[ashfaq_haseeb]

Hi,

look at document analyzer even.

Regards

ASHFAQ

[its_anandrjs]

Hi Khadar,

You have to modify your load script and create separate load scripts for the table load scripts and make the tabs in the load script with all its logic like (Concatenate,Joins, Mappings) in the separate tab. And by doing this create the Start and End time variables to store the loading time of the tables do this step in every tab to store the Start and End times

Ex:-

Let vTablename = 'Customers';

Let vStart = Now();

$(vTablename):

SQL SELECT *

FROM Customers;

Let vEnd = Now();

Let vTotaltime  = Time(vEnd-vStart);

Detail:

LOAD * Inline

[

Starttime,EndTime,TableName

'$(vStart)', ' $(vEnd) '  ,'$(vTablename)'

];

After all this you get the table with details of table name with the start and end time by this you can get which table gets maximum time to reload.

Regards