Possible to use textboxes with dynamic content?

[#1]

Hello,

i have a question regarding the variability of textboxes...

My datasource is:

|ID|TEXTID|LANG|TEXT|

|AB|1|DE|Content 1 Example of ab text|

|AB|2|DE|Content 2 Example of ab Text|

|XY|1|DE|Content 1 Example of xy text|

|XY|2|DE|Content 2 Example of xy Text|

How can i explain to the textbox to display the Text "Content 1 Example of xy text" (s.th. like "=text where ID='XY' and textid='1' and lang='DE').

Is it possible to use a qlikview textbox with dynamic text?

Thank in advance

Jezzeblue

[Miguel_Angel_Baeyens]

Hello Jezzeblue,

You can use variables that get their values from a selected field, and then the text will be the variable

=vText

Or you can use the fields directly, preceding the field name with the "=" sign. I'd prefer to use variables though.

[#3]

Hello Miguel,

thank you very much for your fast reply.

To use the variables i have to define each text as a variable? (40 Textboxes = 40 Variables?)

But also in the variable i have to define which cell to use (like the "where" statement). Do you know which formula is correct?

Thank you

Jezzeblue

[#4]

Hello @ all,

i still don´t know how to solve this problem of textboxes in qlikview. Does anyone might have an idea? I can't reach the texts with a textbox. With a table box i can see all the texts I imported.

Thanx Jezzeblue

[Anonymous · Accepted solution]

Answer for your specific example:
=only(if(ID='XY' and TEXTID=1 and LANG='DE', TEXT))
(or similar logic using Set Analysis syntax)

[#6]

Hi Michael,

GREAT Thank you very much. That was exactly what i was searching for!!!

Regards Jezzeblue