topic Re: AddExpression Macro in QlikView

AddExpression Macro

Wed, 18 Jul 2012 05:40:37 GMT

Hi Guys

i want to add the expression using macro but i want to evaluate also

AddExpression"Sum({<Name = {'var.Item(0).Text '}>} Data)"

The Problem is it is taking everything as a string which is between "" but i want to evaluate var.Item(0).Text

Please help

deepakk — Wed, 18 Jul 2012 06:08:34 GMT

hi,

Try this code.

Graph.AddExpression "Sum({<Name = {" & var.Item(0).Text & " }>} Data)"

Deepak

Wed, 18 Jul 2012 06:14:15 GMT

it is giving the error type mismatch

deepakk — Wed, 18 Jul 2012 06:17:20 GMT

just try var.text.

Can you attach an application.

Deepak

Wed, 18 Jul 2012 06:20:12 GMT

thanks bro its working

Wed, 18 Jul 2012 06:24:21 GMT

Can i get the no of rows in a particular table using macro?????????

deepakk — Wed, 18 Jul 2012 11:59:22 GMT

try this code

set TableBox = ActiveDocument.GetSheetObject( "CH01")

v= TableBox.GetRowCount-1