Discussion Board for collaboration related to QlikView App Development.
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.
You can use a variable to name your sheet and display the same variable in the textbox too
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
Can give me little bit idea about these.
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.
Try with =GetActiveSheetId()
and edit the sheet id with the desired name hope it may help you
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
create a variable
vName='Your Sheet Name'
Now in sheet properties use this variable at Title =$(vName)
In text box- =$(vName)
The only option i can think of, is to include the metadata from the app like this:
[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:
Unfortunately this will require a reload, whenever you add a new sheet.
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.