topic Re: Trace fn ? in QlikView

Trace fn ?

nikhilgarg — Fri, 17 Jul 2015 08:57:03 GMT

Hey,

In my script , we are using :

Trace ===Configuration=== ;

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

Thanks

Re: Trace fn ?

alexandros17 — Fri, 17 Jul 2015 09:00:10 GMT

When you load data the

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

===Configuration===

Re: Trace fn ?

er_mohit — Fri, 17 Jul 2015 09:06:14 GMT

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.

Re: Trace fn ?

nikhilgarg — Fri, 17 Jul 2015 09:07:27 GMT

Sorry but i didn't get you

Re: Trace fn ?

alexandros17 — Fri, 17 Jul 2015 09:10:24 GMT

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===

Re: Trace fn ?

nikhilgarg — Fri, 17 Jul 2015 09:14:08 GMT

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

Re: Trace fn ?

Peter_Cammaert — Fri, 17 Jul 2015 09:24:16 GMT

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

Re: Trace fn ?

nikhilgarg — Fri, 17 Jul 2015 09:27:22 GMT

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

Re: Trace fn ?

Kushal_Chawda — Fri, 17 Jul 2015 09:28:13 GMT

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

Re: Trace fn ?

ajaykumar1 — Fri, 17 Jul 2015 09:28:57 GMT

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