Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Trace fn ?

Hey,

In my script , we are using :

Trace ===Configuration=== ;

So does that means that there is a file named "Configuration" ?

Thanks

9 Replies
alexandros17
Partner - Champion III
Partner - Champion III

When you load data the

Trace instruction writes a string you there should be (during loading of script the message

===Configuration===

er_mohit
Master II
Master II

While executing the script , if you want to see the entire script part means what actually going on (like a message form) we use trace function.

So, trace function is just pass the message in entire script execution.

nikhilgarg
Specialist II
Specialist II
Author

Sorry but i didn't get you

alexandros17
Partner - Champion III
Partner - Champion III

Sorry,

wrong cut and paste ....

I meant:

When you load data the trace instruction writes the string you see after the instruction, in your case there should be (during loading of script) the message

===Configuration===

nikhilgarg
Specialist II
Specialist II
Author

ohk , so you mean it just write that string nthing else it does.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Yes (it just writes) and no (it doesn't do anything else)

The only two places where you will see this string is in the Progress Window (very useful to trace the state of your script) and in the log file, although you'll quickly discover that in the  latter the text occurs twice.

The text string in the trace statement allows for $-sign expansion. And that does make it really useful, as you can include information about loads, tables, records, calculations etc. through the use of variables. For example, this one will display the number of rows I just came to load in my internal table:

LET vRows = NoOfRows('InternalTable');

TRACE *** Table InternalTable now contains $(vRows) rows. ;

Never forget to terminate the Trace statement with a semicolon.

Peter

nikhilgarg
Specialist II
Specialist II
Author

Hey,

Thanks Peter, but i am having prob while showing licensed info of people.

Initially i was fetching Qa data for QA Server only. so i made config accordingly. But now, i am fetching data for prod server from QA server. I ahve changed settings but still it is showing me the data for QA only. It is taking QA connection rathert han Prod connection. Can you help me on this?

Plz have a look at:

How to fetch licensed people info in qlikview ?

Thanks

Kushal_Chawda

Trace function is used to display message while reloading the application

suppose you have connection string as below in script

ODBC ........

So you can write Trace "Connection string" before ODBC connection string

during reload you can see this as below

Connection string

Connected

In other words, it's providing comments or display message during reload, so that when reload fails you will be able trace where was the error

ajaykumar1
Creator III
Creator III

Hi,

In you write the below e.g. in script :

let ReloadSalesAfterDate =Date(today()-7);

trace ReloadSalesAfterDate = $(ReloadSalesAfterDate)

In log file you will get ;  trace ReloadSalesAfterDate = 2015-07-10

Its just a like message for our unserstanding to check our result in log files.

Regards,

Ajay