topic using variables in edit scripts in QlikView

using variables in edit scripts

Fri, 10 Dec 2010 07:31:17 GMT

Hi,

Can I use variables in edit script to add extra column??

Thanks,

using variables in edit scripts

Fri, 10 Dec 2010 08:17:20 GMT

Hi Tim,

short answer: YES.

Let vMyVariable =1;

Let vMyVariable2='Counter';

Load

$(vMyVariable1) as $(vMyVariable2),

Field1

From .........

Please see QV Help and search for LET and SET.

Good luck!

Rainer

using variables in edit scripts

Tue, 14 Dec 2010 10:35:54 GMT

I have one excel sheet with the following fields Product, Qty, Price. I want to calculate Total Amount while creating the table box.
Its not possible to use expression if I want table object, so I decided to create variable and use it in the table box, but I am not sure how to do this

As you said use LET and SET options, but I am not that much familiar with this tool.

Kindly assist.

Thanks,

using variables in edit scripts

Tue, 14 Dec 2010 11:00:55 GMT

Hi Tim,

use a table diagram instead of a table box.

The main difference is that you are able to place expressions by using a table diagram.

Good luck!

Rainer