Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

rickrogers
New Contributor

String field

[Table2]:
Load
Cloth Type,
Req No.,
RESIDENT [Table1];

Is it possible to change the load statement above…

Cloth Type

Req No.

Linen

7369183

Linen

7369075

Linen

7368888

Linen

7200055

Cotton

7369036

Silk

7369173

Silk

7369169

 

…to make a new field named [Req No. String] that looks like this…

Cloth Type

Req No. String

Linen

7369183, 7369075, 7368888, 7200055

Silk

7369173, 7369169

Cotton

7369036

1 Solution

Accepted Solutions
Partner
Partner

Re: String field

Try
[Table2]:
Load
[Cloth Type],
Concat([Req No.], ', ') as [Req No. String]
RESIDENT [Table1]
Group by [Cloth Type]
;
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Partner
Partner

Re: String field

Try
[Table2]:
Load
[Cloth Type],
Concat([Req No.], ', ') as [Req No. String]
RESIDENT [Table1]
Group by [Cloth Type]
;
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post