Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

AddExpression Macro

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

1 Solution

Accepted Solutions
deepakk
Valued Contributor III

Re: AddExpression Macro

hi,

Try this code.

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

Deepak

6 Replies
deepakk
Valued Contributor III

Re: AddExpression Macro

hi,

Try this code.

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

Deepak

Not applicable

Re: AddExpression Macro

it is giving the error type mismatch

deepakk
Valued Contributor III

Re: AddExpression Macro

just try var.text.

Can you attach an application.

Deepak

Not applicable

Re: AddExpression Macro

thanks bro its working

Not applicable

Re: AddExpression Macro

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

deepakk
Valued Contributor III

Re: AddExpression Macro

try this code

set TableBox = ActiveDocument.GetSheetObject( "CH01")

  v=  TableBox.GetRowCount-1

Community Browser