topic Sheet Name function? in QlikView

Sheet Name function?

Thu, 01 Oct 2009 14:45:05 GMT

I'm new to Qlikview, so apologies if there's a simple answer that I've missed from the manual.

Would like to output/concatenate, on each tab, the name of the document + the sheet name (not Sheet ID).

=DocumentTitle() & ???

How can I interpret the Sheet Title ?

Sheet Name function?

Thu, 01 Oct 2009 17:17:25 GMT

Hi John,

The only way I can think of doing this is to run a macro post or pre reload, that cycles through each sheet and uses GetProperties.Name, and creates a variable per sheet with .Name in it. On your sheet you can then just refer to the variable for the current sheet.

I could write this code for you however I'm not in a position to do it right now

-Adam

Sheet Name function?

Thu, 01 Oct 2009 18:50:16 GMT

How about a macro that is fired for each sheet's OnActivate event that sets a variable containing the concatenated document /sheet names? This variables contents is then displayed in a text box.

The OnActivate event is not fired on inital document load with the IE plugin, so you need to have the variable set to the name of the sheet that is initially displayed.

Regards,

Gordon

Sheet Name function?

Thu, 01 Oct 2009 18:55:18 GMT

This looks to be the best and simple way.

-Arun

Re: Sheet Name function?

Wed, 12 Dec 2012 15:20:12 GMT

I just a solution: change the sheet id with the same title sheet; at this point in a text objet i use the GetActiveSheetID function

Ciro