I'm trying to figure out if and how the Qlik concat function works and I'm hoping someone can point me in the right direction.
I have two fields: Origin Country and Destination Country. I'd like to create a third country which combines the two separated by a hyphen, with the combination happening so that the lower country in terms of the alphabet is always first. Here is an example
Origin Country: Germany
Destination Country: Denmark
Concatenated Country: Denmark-Germany
I've reviewed the concat function in the help page and looked around for other examples but I cant quite figure this out. Is the function only available for use in the load script? I don't think so but I wanted to confirm. I'm not looking to create a new column, just an expression for use in one report.