Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sicdude
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
Vegar
Partner
Partner

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
Vegar
Partner
Partner

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