topic Re: static text in QlikView

static text

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

Hi all,

I have a data like below

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 — Mon, 10 Jul 2017 13:30:16 GMT

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

ahaahaaha — Mon, 10 Jul 2017 13:45:57 GMT

Hi,

May be like in attached file

soniasweety — Mon, 10 Jul 2017 13:46:36 GMT

Thank you Kay its working ..

soniasweety — Mon, 10 Jul 2017 13:47:44 GMT

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 — Tue, 11 Jul 2017 08:13:07 GMT

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 — Tue, 11 Jul 2017 10:16:45 GMT

thanks andrey