Show Sheet Name on Text Object

[sat_tok52]

Hi Gurus,

How Would I Show my Sheet Name on Text Object.I tried but it is displaying Sheet Id.But my Requirement is to show Sheet Name.

Thanks All

[ankit777]

You can use a variable to name your sheet and display the same variable in the textbox too

[qlikmsg4u]

I think there is no way (may be I don't know) to show Sheet name (atleast with QV built in functions), one work around is make sheet name as Sheet ID

[sat_tok52]

Can give me little bit idea about these.

[#5]

QV does not have such function to display sheet name but there is a function to display document name (DocumentName()). If you required sheetName,use variable as suggested above.

[avinashelite]

HI

Try with =GetActiveSheetId()

and edit the sheet id with the desired name hope it may help you

[qlikmsg4u]

1.Create a variable vSheetName

2.Assign a value to a variable ex: vSheetName = main

3.Go to sheet properties > Title > =vSheetName

Add the same variable to Texbox to dislay Sheet name

[ankit777]

create a variable

vName='Your Sheet Name'

Now in sheet properties use this variable at Title   =$(vName)

In text box-  =$(vName)

[martin_dideriks]

The only option i can think of, is to include the metadata from the app like this:

SheetNames:

LOAD

    [Sheet/SheetId] AS SheetId,

    [Sheet/Title] AS SheetTitle

FROM Test1.qvw (XmlSimple, Table is [DocumentSummary])

;

Your expression in the TextObject would then look like this:

=MaxString({$<SheetId={"$(=GetActiveSheetId())"}>} SheetTitle)

Unfortunately this will require a reload, whenever you add a new sheet.

//Martin

[James_Kirkpatrick]

Didn't see an answer to this - but its from a long time ago and I believe some updates made this possible now...

1 - Set up a variable vSheetName

2 - For each sheet in the app, go to the sheet properties and have the sheet action define the variable to whatever you're naming the sheet.

3 - Now you can call on the sheet name through the VSheetName variable when you land on that sheet.