In expression set analysis how to concatenate a string to a field?

[#1]

Hi community,  I know in set anaylsis I can do {<leafname=FieldA>} and it gives me what I want.  How do I get {<leafname=FieldA&'OH'>} to work.  I want to add on the OH to the FieldA value for comparison to leafname.

[#2 · Accepted solution]

Hi Brandon,

I think you can load a new field with combine OH to FieldA value, for ex:

LOAD

FieldA&'OH' as FieldAOH

From

xxx.qvd(qvd);

So, next time you can direct using : {<leafname=FieldAOH>} in your expression.

Hope this can help you.

Regards

[#3]

Thats true and works but for some reason when I reloaded the document {<leafname=FieldA>} doesn't work.  What I had tried to do originally was to move the calculated part of a calculated dimension to an expression and it worked just fine until I reloaded.  The original dimension was if(leafname=FieldA,ProfitDim). and I changed the dimension to just ProfitDim and moved the leafname=FieldA to the expression.