-
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.
-
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
-
-
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
-
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.
-
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
-
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
-
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-
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
-
-
-