topic Re: Binary Statement through vbscript in QlikView

Binary Statement through vbscript

brindlogcool — Thu, 27 Nov 2014 10:40:44 GMT

I am trying to create the QlikView Document and add the binary statement using the vbs script. I am able to create the Document and open the Edit script using the below vb script

Set objFSO = CreateObject("Scripting.FileSystemObject")

set qv = CreateObject("QlikTech.QlikView")

Set docObj = qv.CreateDoc

docObj.DialogEditScript

But not finding the way to add the Binary Statement and the Load script. Any suggestions to include the Binary statement and Load script in the above macro

Re: Binary Statement through vbscript

marcus_sommer — Thu, 27 Nov 2014 11:28:35 GMT

Have a look on this example from APIGuide.qvw:

rem ** add new line to script **

set docprop = ActiveDocument.GetProperties

docprop.Script = docprop.Script & "Load * from abc.csv;"

ActiveDocument.SetProperties docprop

- Marcus

Re: Binary Statement through vbscript

brindlogcool — Thu, 27 Nov 2014 16:33:19 GMT

Thanks Marcus for your response.

i tired it for the Binary Load is coming after the set statement. like this

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Binary C:\Users\sds\Desktop\ttt.qvw;

where as i need to place Binary statement. If we are able to clear the set statements then the problem is resolved .

Re: Binary Statement through vbscript

marcus_sommer — Thu, 27 Nov 2014 16:37:17 GMT

Try it with:

docprop.Script = "Binary C:\Users\sds\Desktop\ttt.qvw;" & docprop.Script

- Marcus

Re: Binary Statement through vbscript

brindlogcool — Thu, 27 Nov 2014 17:19:32 GMT

Thanks Marcus for trying to help me out and really appreciate your quick response.

Still the set statements are there

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Binary C:\Users\sds\Desktop\ttt.qvw;///$tab Main

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

I used the script as

Set objFSO = CreateObject("Scripting.FileSystemObject")

set qv = CreateObject("QlikTech.QlikView")

Set docObj = qv.CreateDoc

docObj.DialogEditScript

set docprop = docObj.GetProperties

docprop.Script = docprop.Script & "Binary C:\Users\sds\Desktop\ttt.qvw;"& docprop.Script

docObj.SetProperties docprop

Re: Binary Statement through vbscript

brindlogcool — Fri, 28 Nov 2014 18:27:06 GMT

Hi Marcus,

Thanks for your support. I am not able to close the edit script with macro. I tried to search the API guide but couldn't able to get the details. It would be helpful if you could provide some inputs.

Re: Binary Statement through vbscript

marcus_sommer — Sun, 30 Nov 2014 10:26:38 GMT

Try:

docObj.closedoc 'close application
qv.GetApplication.Quit 'close qlikview

- Marcus

Re: Binary Statement through vbscript

brindlogcool — Sun, 30 Nov 2014 16:41:28 GMT

Hi Marcus,

I tried it is not closing the editscript window.

Re: Binary Statement through vbscript

marcus_sommer — Sun, 30 Nov 2014 18:52:33 GMT

Try this:

docObj.GetApplication.Quit

ActiveDocument.GetApplication.Quit

- Marcus

Re: Binary Statement through vbscript

brindlogcool — Mon, 01 Dec 2014 00:15:50 GMT

Thank you very much for your support

Set objFSO = CreateObject("Scripting.FileSystemObject")

set qv = CreateObject("QlikTech.QlikView")

Set docObj = qv.CreateDoc

docObj.DialogEditScript

docObj.CloseDoc

docObj.GetApplication.Quit

it is not working

Re: Binary Statement through vbscript

marcus_sommer — Mon, 01 Dec 2014 07:53:19 GMT

ActiveDocument.GetApplication.Quit ???

Re: Binary Statement through vbscript

brindlogcool — Mon, 01 Dec 2014 14:31:46 GMT

Thanks Marcus. i tried it is not working.

Re: Binary Statement through vbscript

marcus_sommer — Mon, 01 Dec 2014 15:16:03 GMT

It didn't work because you calls a dialog:

docObj.DialogEditScript

which couldn't be closed by macro-statement (I don't know one unless shortcuts which are NOT recommended) but you don't need these statement then read, change and set the properties from the document is enough.

- Marcus

Re: Binary Statement through vbscript

brindlogcool — Mon, 01 Dec 2014 15:38:59 GMT

Thanks for your response Marcus.

I agree with your comments. I am fine with save and close the QlikView document. I don't need to close the DialogEditScript. But the problem is when the DialogEditScript is open i am not able to close or Quit the application.

If we are able to close the QlikView Document when the DialogEditScript is open then the problem is resolved.

Re: Binary Statement through vbscript

marcus_sommer — Mon, 01 Dec 2014 15:43:07 GMT

Make:

REM docObj.DialogEditScript

and try it again.

- Marcus