Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Man &' '& id &' '& name &' '& ext &' '& value & 'x' & memory & ': this is windows OS' as Description
Man &' '& id &' '& name &' '& ext &' '& value & 'x' & memory & ': this is windows OS' as Description
Hi,
May be like in attached file
Thank you Kay its working ..
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
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
thanks andrey