Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

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
Highlighted
Specialist
Specialist

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

View solution in original post

6 Replies
Highlighted
Specialist
Specialist

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

View solution in original post

Highlighted
Master
Master

Hi,

May be like in attached file

Highlighted
Specialist III
Specialist III

Thank you Kay its working ..

Highlighted
Specialist III
Specialist III

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

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

Highlighted
Specialist III
Specialist III

thanks andrey