Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sat_tok52
Contributor

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

8 Replies
ankit777
Valued Contributor

Re: Show Sheet Name on Text Object

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

qlikmsg4u
Valued Contributor

Re: Show Sheet Name on Text Object

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
Contributor

Re: Show Sheet Name on Text Object

Can give me little bit idea about these.

Not applicable

Re: Show Sheet Name on Text Object

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

HI

Try with =GetActiveSheetId()

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

qlikmsg4u
Valued Contributor

Re: Show Sheet Name on Text Object

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

Re: Show Sheet Name on Text Object

create a variable

vName='Your Sheet Name'

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

In text box-  =$(vName)

Partner
Partner

Re: Show Sheet Name on Text Object

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