Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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