topic SQL select statment in vbscript macro in QlikView

SQL select statment in vbscript macro

Wed, 05 May 2010 09:40:24 GMT

hi,

I need a sql select statement in a macro to query a particular value of a field. How can I do that??

Thanks..

SQL select statment in vbscript macro

tanelry — Wed, 05 May 2010 10:34:26 GMT

If you mean to query value from your loaded data, not external source, then
activedocument.Evaluate()
allows to retrieve or calculate a value using QV native syntax .

sls = activedocument.Evaluate("sum(if(CustomerID=1,Sales))")

SQL select statment in vbscript macro

Wed, 05 May 2010 11:03:19 GMT

Thanks,

yes, I want to query from the loaded data. I am doing the following, but there seems to be an error. What I want to do is to query a field1 of a table, where field2 = 1

s = ActiveDocument.Evaluate("if(COLUMN_1=1,COLUMN_2)")

SQL select statment in vbscript macro

tanelry — Wed, 05 May 2010 11:42:28 GMT

I think you should use some aggregation function, like only()

s = ActiveDocument.Evaluate("only(if(COLUMN_1=1,COLUMN_2))")

I suggest you debug your syntax inside a text object before using in macro. If it works in text object then it works in macro.

SQL select statment in vbscript macro

Wed, 05 May 2010 12:07:43 GMT

Thanks, it works now

SQL select statment in vbscript macro

Thu, 06 May 2010 08:38:12 GMT

Can I evaluate an expression also independently from the selections, including also the not selected values??