topic Re: Qlikview macros using javascript in QlikView

Qlikview macros using javascript

Sat, 01 Nov 2014 11:09:08 GMT

Hello all!

I'm a beginner in Qlikview and I need your help!

I've been looked in Qlikview community but I don't find the solution to my problem. I've generated a macro to resize a ListBox when button is clicking, but is written in VB and I want it to be written in JavaScript.

In VB I have and works:

sub extendheight

set obj = ActiveDocument.GetSheetObject("SelectorsContainer")
   
    set fr = obj.GetFrameDef
    set pos = fr.Rect
    pos.Width = pos.Width
    pos.Height = 1525
    obj.SetFrame fr,true,dummy

End sub

But with JavaScript I've tried:

function extendheight()
{
  var obj = ActiveDocument.GetSheetObject("SelectorsContainer");
  obj.style.Height = 1525;
}

function extendheight()
{
  var obj = document.getElementByID("SelectorsContainer");
  obj.style.Height = 1525;
}

and doesn't work.

Can someone help me?

Thak you for all!

Regards!

Jesús Pau.

Re: Qlikview macros using javascript

ecolomer — Sun, 02 Nov 2014 07:38:33 GMT

Hi,

Attached you have an example

Espero que te ayude

Saludos,

Enrique

Re: Qlikview macros using javascript

Sun, 02 Nov 2014 10:16:11 GMT

Thak you Enrique for you answer!

But I thought in possibility to use JScript code in Qlikview's Macros instead of Macros that are created in VB.

Is it possible to use javascript instead of VB?

Some Idea?

Regards 😃

Re: Qlikview macros using javascript

ecolomer — Sun, 02 Nov 2014 10:33:40 GMT

Yes it is possible, only you need select this option in the macro editor

Re: Qlikview macros using javascript

Sun, 02 Nov 2014 11:37:34 GMT

Thank for API!

Is very useful for me 😃

Muchas Gracias 😃

Re: Qlikview macros using javascript

ashfaq_haseeb — Sun, 02 Nov 2014 11:53:01 GMT

Hi,

Check this too.

http://community.qlik.com/thread/134538

Regards

ASHFAQ

Re: Qlikview macros using javascript

Sun, 02 Nov 2014 13:15:44 GMT

Thank you!

This is a perfect solution!

Regards!

Re: Qlikview macros using javascript

Fri, 22 Apr 2016 22:55:11 GMT

Hi,

Could you please explain me how to do this again? I am trying to get a list of bookmarks using a javascript function.

Here is the VB script function I have -

function bookMarkNames

bookmarks = ActiveDocument.GetDocBookmarkNames

for i = 0 to UBound(bookmarks)

bm = bookmarks(i)

msgbox(bm)

end function

Re: Qlikview macros using javascript

Anonymous — Wed, 09 Aug 2017 16:24:41 GMT

Hi Aniket! Did you find the way to get a list of bookmarks using javascript?

Re: Qlikview macros using javascript

Anonymous — Wed, 09 Aug 2017 16:48:56 GMT

Heh, I got it. Here is the code

function bookMarkNames(){

bookmarks = ActiveDocument.GetDocBookmarkNames().toArray()

for(var i = 0; i < bookmarks.length; i++){

bm = bookmarks

qvlib.msgbox(bm)

}