topic Getting sheet name in Javascript in QlikView

Getting sheet name in Javascript

Anonymous — Thu, 17 Apr 2014 11:36:06 GMT

Hello

Is it possible, in javascript, get the name of the sheet that is currently selected? I'm working in an extension and I need to get that information from QV.

Thanks,

Gabriel

Re: Getting sheet name in Javascript

fkeuroglian — Thu, 17 Apr 2014 14:03:56 GMT

You could get name or ID of active sheet using following expression

ActiveDocument.ActiveSheet.GetProperties.Name

ActiveDocument.ActiveSheet.GetProperties.SheetId

method to get all sheet id

sub LoopSheet

for i = 0 to ActiveDocument.NoOfSheets – 1

set ss= ActiveDocument.GetSheet(i)

msgbox(ss.GetProperties.SheetId)

end sub

good luck

Fernando

Re: Getting sheet name in Javascript

Anonymous — Thu, 17 Apr 2014 16:32:30 GMT

Hi Fernando

Thanks for your help.

But I'm needing something a little different..

I need to get inside the javascript code what sheet is active, 'cause I'm trying to write it in a div that i've created by javascript.

Regards,

Gabriel

Re: Getting sheet name in Javascript

diogopereira89 — Mon, 24 Aug 2015 14:42:09 GMT

Hi Grabriel,

Do you have any news on the subject ?

I've been searching the Javascript API for Qlikview but could not find anything related to the sheetID (only for objects).

Regards,

Diogo Pereira

Re: Getting sheet name in Javascript

Anonymous — Wed, 10 Feb 2016 03:00:38 GMT

I found two ways.

WITH EXPRESSION

1. put this in your definition.xml

2. Then in your script name a var sheetID and put the value from above in it.

var sheetID=this.Layout.Text0.text;

3. Then put this inside the extension or wherever you want it.

var sheetName=document.getElementById(sheetID).querySelector("a").querySelector("span").innerHTML;

WITHOUT EXPRESSION

Just use this *not 100% sure that it works for all situations. As long as selectedtab class for the tabrow is always the first element when it looks for elementsbyclassname

var id=document.getElementsByClassName("selectedtab");

sheetName=id[0].querySelector("a").querySelector("span").innerHTML;