topic Re: Change Fieldname Shown in Search Object Dropdown in QlikView

Change Fieldname Shown in Search Object Dropdown

Thu, 24 Jan 2013 12:05:04 GMT

I've created some search objects with list of selected fields. In the dropdown they are displayed as table.field. How can I lose the table name from the dropdown and also can I change the fieldname at the same time here (if not I can change it in the load script)?

Cheers

Geoff

Re: Change Fieldname Shown in Search Object Dropdown

er_mohit — Thu, 24 Jan 2013 12:10:18 GMT

to change fieldname try

unqualify;

load

data as newdta

here data is my field name..

and write above unqualify if that fieldname comes with your tablename.fieldname

hope it helps

Re: Change Fieldname Shown in Search Object Dropdown

Thu, 24 Jan 2013 15:11:19 GMT

So I guess you're saying that I'll need to do take aout the table name in the load script.

Do you mean like this:-

Table1:

UNQUALIFY;

LOAD
     Field1,
     Field2;
SQL SELECT
     Field1,
     Field2
FROM Table1

QUALIFY;

Re: Change Fieldname Shown in Search Object Dropdown

er_mohit — Fri, 25 Jan 2013 05:22:36 GMT

no.you write in this way:

UNQUALIFY * ;

Table1:

LOAD
     Field1,
     Field2;
SQL SELECT
     Field1,
     Field2
FROM Table1

hope it helps

Re: Change Fieldname Shown in Search Object Dropdown

Fri, 25 Jan 2013 08:12:11 GMT

Unfortunatley this breaks joins later in the load and it's a large fact type table so will need a lot of re-writting (if it's possible without breaking it altogether). Hence I was hoping to find some way to do it post load.

Cheers

Geoff