topic Re: How to Combine two columns? in Water Cooler

How to Combine two columns?

sivaboggarapu20 — Mon, 24 Dec 2018 12:55:53 GMT

Hi Team,

I have two fields like [Origin Country Code]&' - '&[Destination Country Code].

I combined both fields. And I added the above two fields to Dimensions.

But, When drag and drop on Designer Section. Its getting Separated fields. Not giving correct result.

Please look at the attachment. Is there any way i can combine the fields while doing selection

Thanks,

Siva

sunny_talwar — Mon, 24 Dec 2018 13:01:12 GMT

What do you mean when you drop them to Designer section? I am not a pro at Qlik Sense, but do you mean this section?

sivaboggarapu20 — Mon, 24 Dec 2018 13:04:39 GMT

Hi,

The Selection Suppose to Show while making selection.

TrandeLane(Region)='ASPA-MEA'

TrandeLane(Country)='AU-AE'

But above selection getting separated while selected value from fileds

Thanks,

Siva

sunny_talwar — Mon, 24 Dec 2018 13:16:53 GMT

Which fields are you making the selections in? Are you selecting in TrandeLane(Region) and TrandeLane(Country) or the original fields?

dplr-rn — Mon, 24 Dec 2018 13:24:55 GMT

Did you combine the columns in the script or in the app ui? i am guessing the latter

If you make the new dimension as part of script that should achieve what you are saying

Gysbert_Wassenaar — Mon, 24 Dec 2018 15:11:52 GMT

Did you create a new Master Dimension in which you combined the two fields with the expression you posted?