Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
If you click the concatenated field, both state and city should change unless you dont have a relation in your model between them.
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
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
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.
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
subfield('Kansas, Utah, Alabama', ',')
will create three rows.
-Rob
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
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