topic concatenated fields not clickable? in QlikView

concatenated fields not clickable?

Wed, 21 Mar 2012 16:33:19 GMT

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?

Wed, 21 Mar 2012 17:37:47 GMT

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?

rwunderlich — Wed, 21 Mar 2012 17:45:00 GMT

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?

erichshiino — Wed, 21 Mar 2012 17:46:50 GMT

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?

hugo_andrade — Wed, 21 Mar 2012 19:12:39 GMT

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?

Thu, 22 Mar 2012 13:52:29 GMT

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?

rwunderlich — Thu, 22 Mar 2012 16:23:02 GMT

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

will create three rows.

-Rob

concatenated fields not clickable?

Thu, 22 Mar 2012 16:33:59 GMT

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?

erichshiino — Fri, 23 Mar 2012 17:20:09 GMT

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