Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Label Names

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

6 Replies
sunny_talwar

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

gautik92
Specialist III
Specialist III

try this

='Current LTV ' & expr

='Fist LTV' & expr

Not applicable
Author

Expression label name

prajapatiamar38
Creator II
Creator II

Hi

Please find the screen shot of giving label to the expressions

Thanks

gautik92
Specialist III
Specialist III

did yu try my suggestion

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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