topic How can I get the current sheet name in a variable ? in QlikView

How can I get the current sheet name in a variable ?

marcel_olmo — Fri, 15 Oct 2010 17:31:02 GMT

I know there is a function called GetActiveSheetId() that returns the current Id, but how about the current name?

Is there any trick to solve it?

Many thanks in advance.

How can I get the current sheet name in a variable ?

pover — Fri, 15 Oct 2010 17:40:00 GMT

In the QV API, look at the ISheetProperties Class. The following example is how to get to the name of the sheet.

set vSheet=ActiveDocument.GetSheetByID("SH03")
set sp=vSheet.GetProperties
set v = ActiveDocument.Variables("Variable1")

v.SetContent sp.Name,true

Regards.

Then to assign it to a variable

How can I get the current sheet name in a variable ?

marcel_olmo — Fri, 15 Oct 2010 17:45:41 GMT

Thanks Karl, but I want to avoid to do it in the macro script.

Is it possible to do it like a variable?

I mean, you can set a variable like v = GetActiveSheetId() and this would return the id of the variable. And I want exactly the same to get the Name of the sheet.

Is that possible?

Many thanks anyway

How can I get the current sheet name in a variable ?

pover — Fri, 15 Oct 2010 17:52:29 GMT

Not that I know of. It would be much easier to do the reverse and put in the sheet name field a variable.

Regards.

How can I get the current sheet name in a variable ?

marcel_olmo — Fri, 15 Oct 2010 17:57:04 GMT

Ok Karl. Many thanks anyway