8 Replies Latest reply: Mar 23, 2012 1:20 PM by Erich Shiino

concatenated fields not clickable?

Foad Reddahi Mar 21, 2012 12:33 PM

I have for example 2 tables with following values

State City concatenated field

Alabama Huntsville Alabama, Huntsville

Alabama Hoover Alabama, Hoover

Alabama Dothan Alabama, Dothan

Kansas Topeka Kansas, Topeka

Kansas Manhattan Kansas, Manhattan

Kansas Salina Kansas, Salina

Utah Salt Lake city Utah, Salt Lake city

Utah Layton Utah, Layton

Utah Provo Utah, Provo

The problem I have now is that it's not possible to click on the City or State within the Concatenated field.

Is that even possible to click on a value withing a field, meaning If I click on Alabama within the Concatenated field that the 2 other tables change values as well?

concatenated fields not clickable?

Federico Levi Mar 21, 2012 1:37 PM (in response to Foad Reddahi)

If you click the concatenated field, both state and city should change unless you dont have a relation in your model between them.
Like Show 0 Likes (0)

Actions
- concatenated fields not clickable?
  
  Erich Shiino Mar 21, 2012 1:46 PM (in response to Federico Levi)
  
  It will work as Federico described.
  As an alternative you could use a table box with both fields. There the user would be able to select State or City, istead of a concatenated field
  
  Regards,
  
  Erich
  
  Like Show 0 Likes (0)
  
  Actions
concatenated fields not clickable?

Rob Wunderlich Mar 21, 2012 1:45 PM (in response to Foad Reddahi)

How are you creating the concatenated field? Is this a chart calculated dimension or expression? Or are you creating the field in the script, and if so is it linked to the other fields?

-Rob
Like Show 0 Likes (0)

Actions
concatenated fields not clickable?

Hugo Andrade Mar 21, 2012 3:12 PM (in response to Foad Reddahi)

Reload the City, State and the concatenated field:
Load
State,
City,
State &', '&City as State_City
From
Site.qvd (qvd);

And you can display the way you prefer.
Like Show 0 Likes (0)

Actions
concatenated fields not clickable?

Foad Reddahi Mar 22, 2012 9:52 AM (in response to Foad Reddahi)

thanks guys,

I'm using the Concat(City, ',') expression.

I'm actually looking for the reverse option as well.

when we have a record with the following values 'Kansas, Utah, Alabama'.

Is there a way to use string manipulation with a comma or comma delimited to get every value out of this into a table.

Regards
fred
Like Show 0 Likes (0)

Actions
- concatenated fields not clickable?
  
  Rob Wunderlich Mar 22, 2012 12:23 PM (in response to Foad Reddahi)
  
  subfield('Kansas, Utah, Alabama', ',')
  
  will create three rows.
  
  -Rob
  
  Like Show 0 Likes (0)
  
  Actions
  - concatenated fields not clickable?
    
    Foad Reddahi Mar 22, 2012 12:33 PM (in response to Rob Wunderlich )
    
    Rob, thanks for the reply
    
    I know it works with subfield when you hardcoded.
    I tried subfield(City, ',') but that only gives the first value Kansas.
    
    the problem is: today the concatenated table contains 3 cities, tomorrow that could be 12 cities.
    So hardcoding the cities into the expression is not a solution, it should be dynamic
    
    Like Show 0 Likes (0)
    
    Actions
    - concatenated fields not clickable?
      
      Erich Shiino Mar 23, 2012 1:20 PM (in response to Foad Reddahi)
      
      Hi,
      You can see an example of this case in my answer to this post:
      http://community.qlik.com/message/125054#125054
      There is also another example (from Sridhar) in the same thread which shows Rob's suggestion
      
      Hope this helps,
      
      Erich
      
      Like Show 0 Likes (0)
      
      Actions

Go to original post