Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.