Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Merge two fields as one dimension

So I have data for a softball team from each of their games.   I would like to see some game by game trending, but each game does not have a unique id.   The ID comes from the Tournament# and the Game# .   Is it possible in the expression editor to use both fields combined as a single dimension?  IE: T1G1, or T2G5?   This isn't a concatenation, but more a "key" scenario

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Merge two fields as one dimension

You can concatenate  the fields in the script or a calculated dimension into the app.

Script:

Load

[Tournament#] &  [Game#] as ID,

[Tounament#],

[Game#]

From source;

 

Calculated Dimension

= [Tournament #] & [Game#]

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: Merge two fields as one dimension

You can concatenate  the fields in the script or a calculated dimension into the app.

Script:

Load

[Tournament#] &  [Game#] as ID,

[Tounament#],

[Game#]

From source;

 

Calculated Dimension

= [Tournament #] & [Game#]

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post