Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Mi spiace ma non è possibile ... a meno che non utilizzi una variabile o una espressione condivisa in entrambi gli oggetti (Textbox e Sheet)
Mi spiace ma non è possibile ... a meno che non utilizzi una variabile o una espressione condivisa in entrambi gli oggetti (Textbox e Sheet)
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
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.
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.