topic Possible to use textboxes with dynamic content? in QlikView

Possible to use textboxes with dynamic content?

Wed, 23 Jun 2010 08:41:25 GMT

Hello,

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

My datasource is:

|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

Possible to use textboxes with dynamic content?

Miguel_Angel_Baeyens — Wed, 23 Jun 2010 08:49:54 GMT

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.

Possible to use textboxes with dynamic content?

Wed, 23 Jun 2010 09:21:12 GMT

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

Possible to use textboxes with dynamic content?

Wed, 23 Jun 2010 14:09:53 GMT

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

Possible to use textboxes with dynamic content?

Anonymous — Wed, 23 Jun 2010 14:16:23 GMT

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

Possible to use textboxes with dynamic content?

Wed, 23 Jun 2010 15:16:00 GMT

Hi Michael,

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

Regards Jezzeblue