Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sat_tok52
Creator
Creator

Show Sheet Name on Text Object

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

9 Replies
ankit777
Specialist
Specialist

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

qlikmsg4u
Specialist
Specialist

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
Creator
Creator
Author

Can give me little bit idea about these.

Not applicable

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
Specialist
Specialist

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
Specialist
Specialist

create a variable

vName='Your Sheet Name'

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

In text box-  =$(vName)

martin_dideriks
Partner - Contributor III
Partner - Contributor III

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
Contributor II
Contributor II

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.