topic Re: Label Names in QlikView

Label Names

Tue, 25 Aug 2015 10:29:07 GMT

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

Re: Label Names

sunny_talwar — Tue, 25 Aug 2015 10:31:13 GMT

Are we talking about expression label or the label at the top of the table???

Re: Label Names

gautik92 — Tue, 25 Aug 2015 10:33:22 GMT

try this

='Current LTV ' & expr

='Fist LTV' & expr

Re: Label Names

Tue, 25 Aug 2015 10:36:34 GMT

Expression label name

Re: Label Names

prajapatiamar38 — Tue, 25 Aug 2015 10:40:49 GMT

Please find the screen shot of giving label to the expressions

Thanks

Re: Label Names

gautik92 — Tue, 25 Aug 2015 10:42:47 GMT

did yu try my suggestion

Re: Label Names

Peter_Cammaert — Tue, 25 Aug 2015 10:53:19 GMT

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