Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
prabhas277
Creator
Creator

listbox

name of fields is A1,,B2,C3 IN FRONT END WANT SEE LIKE    A OR B OR C  OR  1,2,3

13 Replies
buzzy996
Master II
Master II

try this in ur expression,

=If(col='A1','A',

If(col='B2','B',

If(col='C3','C',NULL())))

OR

=If(col='A1','1',

If(col='B2','2',

If(col='C3','3',NULL())))

rajkumarb
Creator II
Creator II

HI Prabhas

Looking For Some thing Like This

Anonymous
Not applicable

try

Edit Expression  in your   listbox

if(nameField=A1,1,

nameField=B2,2,

nameField=C3,3)

if(nameField=A1,A,

nameField=B2,B,

nameField=C3,C)

if(nameField=A1,1,

nameField=B2,2,3)

if(nameField=A1,A,

nameField=B2,B,C)

Regards!

anbu1984
Master III
Master III

Do you want to display field names in your data model or values of a field?

qlikpahadi07
Specialist
Specialist

you can use left (field,1) or right (field,2)

vishsaggi
Champion III
Champion III

HI Prabhas,

As Anbu said above you want display field or Values of that field, Please let us know.

However, You can use LEFT() and RIGHT() functions to get what you are looking.

Expression1: LEFT(FieldName, 1)

Expression2: RIGHT(FIeldName,1)

Regards,
Vish.

robert_mika
Master III
Master III

LOAD

A1 as A,

B1  as B,

C1 as C

FROM your data source...

Anonymous
Not applicable

=If(Value='A1','A',if(Value='B1','B',if(Value='C1','C')))

prabhas277
Creator
Creator
Author

HI

I want display the field names in the front end.

regards,

suresh