topic Re: With out Rename in QlikView

With out Rename

NavinReddy — Tue, 04 Jun 2013 08:19:49 GMT

Hi All,

I have a Query will some help me

LOAD * INLINE [

Place

Ban

Hyd

Del

Kol

];

display the field names as full form like

Ben-Bangalore

Hyd-Hyderabad

Del-Delhi

Kol-Kolkotta

without using rename option

Thanks & Regards

Niranjan

Re: With out Rename

sujeetsingh — Tue, 04 Jun 2013 08:34:10 GMT

Hi,

it seems you are trying correlate the full names.

See this sample.

Re: With out Rename

NavinReddy — Tue, 04 Jun 2013 08:42:08 GMT

Hi Sardar,

yes ,it should disply full names im using personal edision will you please copy and paste it here

Thanks & Regards

Niranjan

Re: With out Rename

sujeetsingh — Tue, 04 Jun 2013 08:50:46 GMT

Are you not able to get htis sample.

You can use this type code

=if(City='DL','Delhi',

if(City='PU','Pune',

if(City='NAG','nagpur')))

Re: With out Rename

kumarnatarajan — Tue, 04 Jun 2013 08:57:32 GMT

Hi,

try this to your list box expression

Ex:

=if(Place='Ban','Bangalore',

if(Place='Hyd','Hyderabad',

if(Place='Del','Delhi',

if(Place='Kol','Kolkotta'))))

see below screen short.

Re: With out Rename

er_mohit — Tue, 04 Jun 2013 09:04:49 GMT

Yeah its possible through inline load

see example

PP:

mapping LOAD * INLINE [

Place,Name

Bang,Banglore

Hyd,Hyderabad

Del,Delhi

Kol,Kolkatta

];

Map Place using PP;

LOAD * INLINE [

Place

Bang

Hyd

Del

Kol

];

Re: With out Rename

NavinReddy — Tue, 04 Jun 2013 09:17:31 GMT

Hi All,

Thanks a lot for replay

Thanks & Regards

Niranjan