Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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.