topic Re: listbox in QlikView

listbox

prabhas277 — Wed, 08 Apr 2015 16:14:05 GMT

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

Re: listbox

buzzy996 — Wed, 08 Apr 2015 16:18:51 GMT

try this in ur expression,

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

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

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

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

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

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

Re: listbox

rajkumarb — Wed, 08 Apr 2015 16:27:47 GMT

HI Prabhas

Looking For Some thing Like This

Re: listbox

Anonymous — Wed, 08 Apr 2015 16:28:26 GMT

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!

Re: listbox

anbu1984 — Thu, 09 Apr 2015 05:02:31 GMT

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

Re: listbox

qlikpahadi07 — Thu, 09 Apr 2015 05:09:31 GMT

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

Re: listbox

vishsaggi — Thu, 09 Apr 2015 05:12:59 GMT

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.

Re: listbox

robert_mika — Thu, 09 Apr 2015 05:39:52 GMT

LOAD

A1 as A,

B1 as B,

C1 as C

FROM your data source...

Re: listbox

Anonymous — Thu, 09 Apr 2015 06:07:40 GMT

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

Re: listbox

prabhas277 — Thu, 09 Apr 2015 06:15:15 GMT

I want display the field names in the front end.

regards,

suresh

Re: listbox

Thu, 09 Apr 2015 06:21:58 GMT

Hi prabhas,

A1,B2,C3 ARE field names ?

t1:

FROM SALES.XLSX

NOW U WANT TO DISPLAY A1 AS A AND B1 AS B AND C3 AS C IN FRONT END RIGHT ?

Re: listbox

anbu1984 — Thu, 09 Apr 2015 06:22:44 GMT

Then rename your fields in script as suggested by Robert below

Re: listbox

Thu, 09 Apr 2015 06:29:38 GMT

use alias name

input field and change it in front end how u want like a or 1

Re: listbox

prabhas277 — Thu, 09 Apr 2015 06:39:57 GMT

Hi manojqlik

Alias is fine but,

By using input field we can change the values only in the list box. but my aim is change the field names .so as of my knowledge it is not possible.

Regards

prabhas