Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: AddExpression Macro

hi,

Try this code.

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

Deepak

View solution in original post

6 Replies
Highlighted
Partner
Partner

Re: AddExpression Macro

hi,

Try this code.

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

Deepak

View solution in original post

Highlighted
Not applicable

Re: AddExpression Macro

it is giving the error type mismatch

Highlighted
Partner
Partner

Re: AddExpression Macro

just try var.text.

Can you attach an application.

Deepak

Highlighted
Not applicable

Re: AddExpression Macro

thanks bro its working

Highlighted
Not applicable

Re: AddExpression Macro

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

Highlighted
Partner
Partner

Re: AddExpression Macro

try this code

set TableBox = ActiveDocument.GetSheetObject( "CH01")

  v=  TableBox.GetRowCount-1