static text

[soniasweety]

Hi all,

I have a data like below

Man	id	name	ext	value	memory	number	os	config
HEW	PKD	DLMN380	G8	16	128	1234	WINDOWS	32bit
HEW	PKD	DLMN381	G9	17	128	1235	WINDOWS	32bit
HEW	PKD	DLMN382	G10	18	128	1236	WINDOWS	32bit
HEW	PKD	DLMN383	G11	19	128	1237	WINDOWS	32bit
HEW	PKD	DLMN384	G12	20	128	1238	WINDOWS	32bit
HEW	PKD	DLMN385	G13	21	128	1239	WINDOWS	32bit

I need output like below

in this after colon "this is windows OS "  should be given to all the numbers  rest all to be concatenate the columns with spaces.

as a separate column as Description

HEW PKD DLMN380 G8 16x128: this is windowsOS

HEW PKD DLMN381 G9 17x128: this is windowsOS

how can I achieve this?

[aarkay29 · Accepted solution]

Man &' '& id &' '& name &' '& ext &' '& value & 'x' &  memory & ': this is windows OS' as Description

[ahaahaaha]

Hi,

May be like in attached file

[soniasweety]

Thank you Kay its working ..

[soniasweety]

Andrey,

I cannot open Qvw as I don't have Qlikview. using Qliksense

if possible paste two screen shots of script and output .

Thanks

Sony

[ahaahaaha]

Hi Sony,

For QlikView Text box with expression

= Concat(Man&' '&id&' '&name&' '&value&'x'&memory&': this is'&Chr(13)&Chr(10)&

os&'OS', Chr(13))

Result

For  Qlik Sense example at attached file.

Regards,

Andrey

[soniasweety]

thanks andrey