topic Help in QlikView

Help

NavinReddy — Thu, 29 Aug 2013 06:23:19 GMT

Hi All,

I have plenty variables

atleast i need to be put five varibles in one text object

I know one varible we can put in text object

is there any way to put 5varibles in one object

help me some one

Thanks in Avance

rohith

tresB — Thu, 29 Aug 2013 06:25:35 GMT

This?

=Variable1& 'Your String' & Variable2 & Variable3

'&' is string concatenation operator

jfkinspari — Thu, 29 Aug 2013 06:27:18 GMT

It's easy.

Just add all the wanted variables to the textbox.

Like if you have 3 variables names Var1, Var2 and Var, your expression in the text box could like

Var1 & ' ' & Var2 & ' ' & Var3

This will make a space between the variables.

mr_janne — Thu, 29 Aug 2013 06:28:11 GMT

tresescos reply is correct and if you like to implement line feeds you can use:

= Variable1 & chr(10) & Variable2 etc.

regards. Janne

nilesh_gangurde — Thu, 29 Aug 2013 06:28:43 GMT

Dear niranjan,

if i have 2 variables : variable 1 = vTOP and variable 2 = vTDAmount

then we can display both in text object as follows:

='$(VTOP)' & '$(vTDAmount)'

-Nilesh

MayilVahanan — Thu, 29 Aug 2013 06:29:38 GMT

Try like this

='1' & Variable1 & '2 ' & variable2 &' 3' & variable3 &' 4' & variable4 & ' 5 '& variable5

Hope that helps