topic Re: Dynamic Text Object in QlikView

Dynamic Text Object

navaneeth79 — Fri, 29 Sep 2017 09:19:37 GMT

Hi all,

Can we create a text box object with a static statement and a dynamic statement?

for example,

MY NAME IS NAVANEETH

here MY NAME IS should be seen always

and NAVANEETH should change to some other name if any other file is uploaded into the application.

Thanks,

Navaneeth.

Re: Dynamic Text Object

swuehl — Fri, 29 Sep 2017 09:31:37 GMT

Use an expression in the text box like

='MY NAME IS ' & Maxstring(FieldwithName)

Re: Dynamic Text Object

arvind_patil — Fri, 29 Sep 2017 10:30:31 GMT

Hi Navneeth,

May be like this:

Here vName= Name of as you want

='My name is '&$(vName)

='Date is '&Today()

Thanks,

Arvind Patil

Re: Dynamic Text Object

navaneeth79 — Fri, 29 Sep 2017 10:37:45 GMT

hi Stefan, can I take the filed with name from a file

Re: Dynamic Text Object

swuehl — Fri, 29 Sep 2017 10:42:22 GMT

Sure, but you need to describe the data source and how you want to extract the data from it.

Is it just a table load?

Re: Dynamic Text Object

navaneeth79 — Fri, 29 Sep 2017 10:45:19 GMT

yes, its table file (excel sheet)

Re: Dynamic Text Object

swuehl — Fri, 29 Sep 2017 10:49:28 GMT

Ok... but could you be a bit more descriptive in your setting and requirement?

Re: Dynamic Text Object

navaneeth79 — Fri, 29 Sep 2017 10:52:01 GMT

I get data for different services, when I load data into the application , in the main text box that service name should be shown.

Re: Dynamic Text Object

swuehl — Fri, 29 Sep 2017 11:03:07 GMT

From what I've understood so far (but still missing a lot):

='MY NAME IS ' & Concat(DISTINCT ServiceName, ', ')

Coming back to your original question, you can combine a static text with any expression by using a text literal in single quotes and concatenation operator & in combination with your expression that returns the dynamic part.

Re: Dynamic Text Object

navaneeth79 — Fri, 29 Sep 2017 11:06:05 GMT

Thanks for the valuable knowledge, I got the required answer