Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

concatenated fields not clickable?

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?

8 Replies
Not applicable
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

erichshiino
Partner - Master
Partner - Master

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

hugo_andrade
Partner - Creator II
Partner - Creator II

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.

Not applicable
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

subfield('Kansas, Utah, Alabama', ',')

will create three rows.

-Rob

Not applicable
Author

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

erichshiino
Partner - Master
Partner - Master

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