topic Re: Show Sheet Name on Text Object in QlikView

Show Sheet Name on Text Object

sat_tok52 — Tue, 09 Jun 2015 12:17:58 GMT

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

Re: Show Sheet Name on Text Object

ankit777 — Tue, 09 Jun 2015 12:21:05 GMT

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

Re: Show Sheet Name on Text Object

qlikmsg4u — Tue, 09 Jun 2015 12:21:45 GMT

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

Re: Show Sheet Name on Text Object

sat_tok52 — Tue, 09 Jun 2015 12:24:22 GMT

Can give me little bit idea about these.

Re: Show Sheet Name on Text Object

Tue, 09 Jun 2015 12:27:40 GMT

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.

Re: Show Sheet Name on Text Object

avinashelite — Tue, 09 Jun 2015 12:28:34 GMT

Try with =GetActiveSheetId()

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

Re: Show Sheet Name on Text Object

qlikmsg4u — Tue, 09 Jun 2015 12:28:41 GMT

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

Re: Show Sheet Name on Text Object

ankit777 — Tue, 09 Jun 2015 12:29:52 GMT

create a variable

vName='Your Sheet Name'

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

In text box- =$(vName)

Re: Show Sheet Name on Text Object

martin_dideriks — Tue, 09 Jun 2015 12:32:53 GMT

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

Re: Show Sheet Name on Text Object

James_Kirkpatrick — Thu, 22 Apr 2021 15:03:32 GMT

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.