Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have straight table(Adhoc report).. and multiple expressions and I need lable names as per the selection
ex:
Filter(List box)
%Expression
Current LTV
Fist LTV
Counter
LEQ Rate
Straight table:
Expr1 Expr2 Expr3 Expr4....etc
Lable names should like
Expr1=Current LTV Expr2=Fist LTV Expr3=Counter Expr4=LEQ Rate
Are we talking about expression label or the label at the top of the table???
try this
='Current LTV ' & expr
='Fist LTV' & expr
Expression label name
Hi
Please find the screen shot of giving label to the expressions
Thanks
did yu try my suggestion
Since you are dealing with fixed expressions that are shown only on condition that their name is selected from list box %Expression, you can add a fixed label to each expression just like the name provided in the list box.
On the other hand, if you only want to define the expression names in a single place (e.g. the INLINE table used to create field %Expression), you may want to experiment with FieldValue() to obtain the current label from a fixed position in field %Expression, like
=FieldValue('%Expression', 2)
But I think this is more effort than it's worth. And whenever QV decides (usually without warning) to order %Expression values in a different way, your indices will become incorrect.
Peter