Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

static text

Hi all,

I have a data like below

   

Manidnameextvaluememorynumberosconfig
HEWPKDDLMN380G8161281234WINDOWS32bit
HEWPKDDLMN381G9171281235WINDOWS32bit
HEWPKDDLMN382G10181281236WINDOWS32bit
HEWPKDDLMN383G11191281237WINDOWS32bit
HEWPKDDLMN384G12201281238WINDOWS32bit
HEWPKDDLMN385G13211281239WINDOWS32bit

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?

   

1 Solution

Accepted Solutions
aarkay29
Specialist
Specialist

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

View solution in original post

6 Replies
aarkay29
Specialist
Specialist

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

ahaahaaha
Partner - Master
Partner - Master

Hi,

May be like in attached file

soniasweety
Master
Master
Author

Thank you Kay its working ..

soniasweety
Master
Master
Author

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
Partner - Master
Partner - Master

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

1.jpg

For  Qlik Sense example at attached file.


Regards,

Andrey

soniasweety
Master
Master
Author

thanks andrey