topic Re: Trace() in QlikView

Trace()

Wed, 13 Nov 2013 14:14:19 GMT

What is the purpose of this function? Would someone put up a quick example?

Re: Trace()

MayilVahanan — Wed, 13 Nov 2013 14:17:26 GMT

Please refer the help file

The trace statement writes a string to the Script Execution Progress window and to the script log file, when used.

It is very useful for debugging purposes. Using $-expansions of variables that are calculated prior to the Trace statement, you can customize the message.

The syntax is:

trace string

Examples:

trace Main table loaded;

Let MyMessage = NoOfRows('MainTable') & ' rows in Main Table';

trace $(MyMessage);

Re: Trace()

Anonymous — Wed, 13 Nov 2013 14:17:33 GMT

Chris

To put text in the reload log / on the screen during a reload;

trace Test Message ;

Best Regards, Bill

Re: Trace()

Wed, 13 Nov 2013 14:20:29 GMT

The Trace function log the your comments to Log file. Just providing the comments in the Log file as well.

Re: Trace()

Wed, 13 Nov 2013 14:21:27 GMT

Thanks for the answers everyone. That clears it up.

Re: Trace()

Colin-Albert — Wed, 13 Nov 2013 14:24:50 GMT

I always put a trace command at the start of each tab in the load script.
This allows you to see the progress of the load and assists in debugging errors.

trace ; puts a blank line in the log / execution progress window

trace === <Your Tab Name> === ;

trace ;

load....

Re: Trace()

Wed, 13 Nov 2013 14:26:56 GMT

Helpful tip, thanks Colin.