topic How to reference the caption/title of another object? in QlikView

How to reference the caption/title of another object?

Fri, 28 Feb 2014 11:05:41 GMT

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.

Re: How to reference the caption/title of another object?

alexandros17 — Fri, 28 Feb 2014 11:09:13 GMT

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

Re: How to reference the caption/title of another object?

sunilkumarqv — Fri, 28 Feb 2014 11:13:08 GMT

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

Re: How to reference the caption/title of another object?

ThornOfCrowns — Fri, 28 Feb 2014 11:44:23 GMT

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.

Re: How to reference the caption/title of another object?

Fri, 28 Feb 2014 13:55:18 GMT

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.