topic How to see values stored in variable ? in QlikView

How to see values stored in variable ?

Mon, 22 Jul 2013 08:55:20 GMT

Like in unix shell scripts or oracle we can see the value that was stored in a variable using echo $variable , dbms.output.putline() respectively...

Similarly , how can i see the value stored in a variable using my script ?? is there any command available ?? or i can see it only in the list box.??

Re: How to see values stored in variable ?

tresB — Mon, 22 Jul 2013 08:57:36 GMT

command : TRACE $(YourVariable)

Re: How to see values stored in variable ?

Mon, 22 Jul 2013 09:54:11 GMT

Thanks for your reply. In the script editor , I included a line as below

Let VData='Test Display' &'-'&'Value';

TRACE $(VData);

When I try to display it in a text object to see the output of my variable value

=TRACE $(VData); it was not showing any value

Regards

Sathya

Re: How to see values stored in variable ?

tresB — Mon, 22 Jul 2013 09:57:38 GMT

try sleep(10000) after trace .

Re: How to see values stored in variable ?

Mon, 22 Jul 2013 10:01:55 GMT

thanks for your quick reply, I could see the value while running the .qvw file. But can I display that in a text object ?? how ?

Re: How to see values stored in variable ?

Mon, 22 Jul 2013 10:04:35 GMT

U can debug the code one by one instead of reload.

Regards,

Kabilan K.

Re: How to see values stored in variable ?

tresB — Mon, 22 Jul 2013 10:05:47 GMT

front end?

text box expresssion: = $(variablename)

Re: How to see values stored in variable ?

Mon, 22 Jul 2013 10:07:19 GMT

and u can display the varible in text box through below structure.

=$(YourVariableName)

Regards,

Kabilan K.

Re: How to see values stored in variable ?

Mon, 22 Jul 2013 10:19:13 GMT

thanks .. I could see the output for the variable value while doing debug step by step..

But with the above expression it was not displaying the value in the front end text object ??

=$(VData);

Re: How to see values stored in variable ?

kaushiknsolanki — Mon, 22 Jul 2013 10:24:17 GMT

Hi,

Make sure that the variables actually holds the value once the script execution is finished.

To make sure this, you can go to setting -> variable overview.

Here you will find all the variables and their values.

If the variable has the value, then create a text box and use =VData and it will show values.

Regards,

Kaushik Solanki

Re: How to see values stored in variable ?

tresB — Mon, 22 Jul 2013 10:24:48 GMT

remove semicolon

Re: How to see values stored in variable ?

Mon, 22 Jul 2013 10:25:24 GMT

try, just give a =VData

Re: How to see values stored in variable ?

Mon, 22 Jul 2013 10:28:16 GMT

Thanks Kaushik and the rest.

I could see the value for the variable VData in the Variable overview. I should not use =$(VData) instead if I use =VData (without $) it displays the value in the text object .

Re: How to see values stored in variable ?

Mon, 22 Jul 2013 10:47:15 GMT

Hi ,

I was trying to see the value returned by the below QVD functions such as QvdNoOfRecords etc... But I could see the values stored in the variables ???? Please help

Let qvdcrtime=QvdCreateTime($(SD)dept11.qvd);

Let qvdNoOfRec=QvdNoOfRecords($(SD)dept11.qvd);

Let qvdTabName=QvdTableName($(SD)dept11.qvd);

Trace $qvdcrtime;

Trace $qvdNoOfRec;

Trace $qvdTabName;

Regards

Sathya

Re: How to see values stored in variable ?

Mon, 22 Jul 2013 10:48:20 GMT

For your quick review , the syntax copied it here..

QvdCreateTime( filename ) - Returns the XML-header time stamp from a QVD file if any (otherwise NULL).

QvdNoOfRecords( filename ) - Returns the number of records currently in a QVD file.

QvdNoOfFields( filename ) - Returns the number of fields in a QVD file.

QvdFieldName( filename ) - Returns the name of field number field_no, if it exists in a QVD file (otherwise NULL).

QvdTableName( filename ) - Returns the name of the table contained in a QVD file.

Re: How to see values stored in variable ?

kaushiknsolanki — Mon, 22 Jul 2013 10:50:06 GMT

Try this way.

QvdCreateTime('FileName');

File name should be in quote.

Regards,

Kaushik Solanki

Re: How to see values stored in variable ?

Mon, 22 Jul 2013 10:56:27 GMT

Its working, you're awesome //

Thanks Kaushik