Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to reference the caption/title of another object?

Hello, I'm new in qlikview, i already tried to serch about this subject but i found nothing.

I would like to have the text of a textbox equal to the title of the sheet in which the textbox is in. How can I reference it?

Thanks in advance.

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

Mi spiace ma non è possibile ... a meno che non utilizzi una variabile o una espressione condivisa in entrambi gli oggetti (Textbox e Sheet)

View solution in original post

4 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Mi spiace ma non è possibile ... a meno che non utilizzi una variabile o una espressione condivisa in entrambi gli oggetti (Textbox e Sheet)

sunilkumarqv
Specialist II
Specialist II

Try this

Example you make this expession  in text obj and change below followed to you FieldNames and same exp copy into Chart window title.

='FieldNames'  & If(GetSelectedCount(FieldName)>0, GetFieldSelections(FieldName)) &' ' &

  If(GetSelectedCount(FieldName1)>0, GetFieldSelections(FieldName1)) &' ' &

  If(GetSelectedCount(FieldName2)>0, GetFieldSelections(FieldName2)) &' ' &

Hope you get desired Result

ThornOfCrowns
Specialist II
Specialist II

That will pick up a selected field, OP wants to be able to use the raw Sheet Name, i.e. no selections, which I don't think is possible.

Not applicable
Author

Thanks to everyone. I solved creating a variable that is set to the name of the sheet everytime a button is clicked (this is a menu button which task is to change sheet). In this way I can use a linked textbox in every sheet which text is set dynamically clicking on the menu button.