Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
navaneeth79
Contributor II
Contributor II

Dynamic Text Object

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.

1 Solution

Accepted Solutions
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Navneeth,

May be like this:

Here vName= Name of  as you want

='My name is '&$(vName)

='Date is '&Today()

Thanks,

Arvind Patil

View solution in original post

9 Replies
swuehl
MVP
MVP

Use an expression in the text box like

='MY NAME IS ' & Maxstring(FieldwithName)

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Navneeth,

May be like this:

Here vName= Name of  as you want

='My name is '&$(vName)

='Date is '&Today()

Thanks,

Arvind Patil

navaneeth79
Contributor II
Contributor II
Author

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

swuehl
MVP
MVP

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?

navaneeth79
Contributor II
Contributor II
Author

yes, its table file (excel sheet)

swuehl
MVP
MVP

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

navaneeth79
Contributor II
Contributor II
Author

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

swuehl
MVP
MVP

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.

navaneeth79
Contributor II
Contributor II
Author

Thanks for the  valuable knowledge, I got the required answer