
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is Trace Keyword in QlikView
Hi All,
Can anybody tell me what is TRACE Keyword and why it is used with Exmple.....
Sarfaraz
- Tags:
- new_to_qlikview

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
From QlikView Help
Trace
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);
Regards
ASHFAQ

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Ashfaq,
Can you please elaborate the TRACE explanation..still i am confused ....Please attach some output of Trace keyword ...
I tried with the below code :-
TRACE 'C:\Users\Sarfaraz.Sheikh\Desktop\Sarfaraz\TAT Data\COMPLAINS TAT DATA.xls' Loaded;
Let MyMassage=NoOfRows('COMPLAINS TAT DATA.xls') & 'rows in COMPLAINS TAT DATA';
TRACE $(MyMassage);
when i click on reload nothing is appearing or appeared ....what exactly happening after reload i am not understanding...
Request you to please elaborate or attach some output here ...
Regards
Sarfaraz

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Now if you use this Trace in between a long statement, you might not be able to see the output, because that gets executed fast and goes to next statement. If you want the see the output, better use Sleep command to wait for sometime like:
Trace 'Here is your message';
Sleep 2000; // 2000 miliseconds
.....
.....
;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sarfarz,
have a look at attached application.
Its used for debugging purpose.
Hope it helps
Regards
ASHFAQ

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Safaraz
To look at table names & numbers of rows in the gui , create a table with system fields $Table & $Rows.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you give an example of what your trying to do?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ASHFAQ,
Good explanation, but the message flashed, where is the "log" located?
Thank you!
Stephen
