Qlik Community

Ask a Question

App Development

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

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
BearNBeer
Contributor II
Contributor II

Merge two dimension into one

Hello,

I have two dimensions which I am going to call "Dim A" and "Dim B", like this :

BearNBeer_0-1627551560567.png

Is there a way to merge them so they appear like that :

BearNBeer_1-1627551644510.png


Thanks

 

1 Solution

Accepted Solutions
Vegar
MVP
MVP

You can do it in the script by loading the data like this.

 

LOAD ID, SubField([Dim A]&'|'&[Dim B], '|') as [Dim AB] inline [
ID, Dim A, Dim B
1, Dim A1, Dim B4
2, Dim A2, Dim B5
3, Dim A3, Dim B6
]
;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Vegar
MVP
MVP

You can do it in the script by loading the data like this.

 

LOAD ID, SubField([Dim A]&'|'&[Dim B], '|') as [Dim AB] inline [
ID, Dim A, Dim B
1, Dim A1, Dim B4
2, Dim A2, Dim B5
3, Dim A3, Dim B6
]
;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post