Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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