topic In expression set analysis how to concatenate a string to a field? in QlikView

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

Thu, 07 Jun 2012 18:16:29 GMT

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.

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

Thu, 07 Jun 2012 18:25:37 GMT

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

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

Thu, 07 Jun 2012 19:30:03 GMT

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.