Qlik Community

App Development

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

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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