topic Re: Script & in QlikView

Script &

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All ,

I have a field by name "Seriese " un d1er which the content are like

. ans so on

Now i want have DT infron of all the content how do i do this in the script level ?

Sample Example:

Under Dimension ther is a Variable being displayed which is displaying ,

No under the same Dimension iam trying to edit the it like this : 'Diode' & $(Extreme_Diode_CityRank_Descript).

When i do the above change it is not displaying the value but itis just showing Diode thats it ? May i know how can i concatenate this .

Re: Script &

arulsettu — Fri, 04 Mar 2016 05:36:15 GMT

may be this

'DT' & Seriese as Seriese

Re: Script &

smilingjohn — Fri, 04 Mar 2016 05:38:50 GMT

And how about under the dimension ?

Under Dimension ther is a Variable being displayed which is displaying ,

No under the same Dimension iam trying to edit the it like this :

'Diode' & $(Extreme_Diode_CityRank_Descript).

When i do the above change it is not displaying the value but itis just showing Diode thats it ? May i know how can i concatenate this .

Re: Script &

tresB — Fri, 04 Mar 2016 05:40:48 GMT

Try putting single quotes around variable expansion like:

'Diode' & '$(Extreme_Diode_CityRank_Descript)'

Re: Script &

avinashelite — Fri, 04 Mar 2016 05:41:51 GMT

Hi john,

Check whether the variable is getting get properly ...

you can concatenate easily like

filed1 & '-'& field2 as new_field

Re: Script &

Fri, 04 Mar 2016 05:43:10 GMT

'DT' & Seriese as DTSeriese,

Re: Script &

engishfaque — Fri, 04 Mar 2016 06:03:34 GMT

Dear John,

Can you share your sample data and variable expression?

Kind regards,

Ishfaque Ahmed

Re: Script &

smilingjohn — Fri, 04 Mar 2016 06:04:11 GMT

Hi tresco its giving an error

Re: Script &

avinashelite — Fri, 04 Mar 2016 06:10:36 GMT

Try without the $ sign :

'Diode' & Extreme_Diode_CityRank_Descript

Extreme_Diode_CityRank_Descript is a field or variable ??

Re: Script &

tresB — Fri, 04 Mar 2016 06:13:44 GMT

Could you post a sample qvw with inline data perhaps?

Re: Script &

smilingjohn — Fri, 04 Mar 2016 06:18:10 GMT

Its a varibale ,

And again within that ther is a variable

Re: Script &

avinashelite — Fri, 04 Mar 2016 06:22:20 GMT

can you please share the expression what you have written in the variable ??