Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Possible to use textboxes with dynamic content?

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

5 Replies
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.

Not applicable
Author

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

Not applicable
Author

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
Not applicable
Author

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

Not applicable
Author

Hi Michael,

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

Regards Jezzeblue