topic Re: TextObject in QlikView

TextObject

soha1902 — Thu, 14 May 2015 13:59:53 GMT

Hi All,

I have one field name MyField which contains a value like:

MyField

AB-10, ABC9-AB-12, BCDE-15,ZEAB-031-71

Now I want to show this value in Text Object only with
following formatting:

Part1 - Part2

AB - 10

ABC9 - 12

BCDE - 15

ZEAB - 71

Please help to find this.

Thanks.

Re: TextObject

Clever_Anjos — Thu, 14 May 2015 14:06:28 GMT

These values AB-10, ABC9-AB-12, BCDE-15,ZEAB-031-71 are stored in only one record or 4?

Re: TextObject

soha1902 — Thu, 14 May 2015 14:07:36 GMT

Its only one record.

Should Its easy to got the desired output if these are 4 records? If yes then please let me I'll make it as 4 records and then implement the solution.

Re: TextObject

Clever_Anjos — Thu, 14 May 2015 14:10:28 GMT

First you´ll need to split that value at script level

LOAD

somekey,

subfield(MyField,',') as MyFieldSplitted

RESIDENT youtable

Then use this expression inside your texbox

concat(MyFieldSplitted,CHR(10))

Re: TextObject

soha1902 — Thu, 14 May 2015 14:18:13 GMT

I am not getting the correct output. Please find attached qvw.

Re: TextObject

stigchel — Thu, 14 May 2015 14:23:25 GMT

Try with something like this in load script

Data:

Load * Inline [MyField

'AB-10, ABC9-AB-12, BCDE-15,ZEAB-031-71'

];

Load SubField(Lines,'-',1) & '-' & SubField(Lines,'-',SubStringCount(Lines,'-')+1) As NewField;

Load

Trim(SubField(MyField,',')) As Lines

resident Data;

Re: TextObject

soha1902 — Thu, 14 May 2015 14:30:30 GMT

Its showing only AB-10 in Text Box but I want to show all the values as I mentioned in my original post.

Re: TextObject

sunny_talwar — Thu, 14 May 2015 14:32:41 GMT

Maybe this:

='Part1' & Chr(32) & Chr(32) & Chr(32) & '-' & Chr(32) & Chr(32) & Chr(32) & 'Part2' & Chr(13) &

Concat(SubField(SubField('AB-10, ABC9-AB-12, BCDE-15,ZEAB-031-71', ',', ValueLoop(1,4,1)), '-', 1) & Chr(32) & Chr(32) & Chr(32) & '-' & Chr(32) & Chr(32) & Chr(32) &

SubField(SubField('AB-10, ABC9-AB-12, BCDE-15,ZEAB-031-71', ',', ValueLoop(1,4,1)), '-', -1), Chr(13))

Looks like this in a Text Box:

Re: TextObject

stigchel — Thu, 14 May 2015 14:33:06 GMT

See attached

Re: TextObject

stigchel — Thu, 14 May 2015 14:34:26 GMT

Notice the quotation marks around the original string in the inline load in my example that are missing in your file

Re: TextObject

crusader_ — Thu, 14 May 2015 14:34:40 GMT

Hi,

So modify it a little bit

Data:

Load * Inline [MyField

'AB-10, ABC9-AB-12, BCDE-15,ZEAB-031-71'

];

LOAD Concat(_NewField,chr(13)) as NewField;

Load SubField(Lines,'-',1) & '-' & SubField(Lines,'-',SubStringCount(Lines,'-')+1) As _NewField;

Load

Trim(SubField(MyField,',')) As Lines

resident Data;

Stigchel‌very nice solution

Re: TextObject

sunny_talwar — Thu, 14 May 2015 14:36:20 GMT

Notice the quotation marks around the original string in the inline load in my example that are missing in your file

I am not sure what you mean Piet‌? Is this for me?

Re: TextObject

Clever_Anjos — Thu, 14 May 2015 14:38:16 GMT

Please add quotes

Tab1:

Load * Inline [

Myfield

"AB-10,ABC9-AB-12,BCDE-15,ZEAB-031-71" ];

Tmp:

join LOAD

subfield(Myfield,',') as MyFieldSplitted

RESIDENT Tab1;

Re: TextObject

Clever_Anjos — Thu, 14 May 2015 14:39:52 GMT

Re: TextObject

stigchel — Thu, 14 May 2015 14:46:05 GMT

No it was not Sunny, in the the sample that was attached by Soha1902 these were not in the inline load