Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vibhapratha
Contributor II
Contributor II

Rename field inside Table Box

Hi, 

I created a Table box with various columns. One of the columns 'Product' has filed values = 'FXFORW' ,'FXSPOT',etc . I need to export it to excel and I need to rename all these values in 'Product' column as 'Forward','Spot' ,etc   respectively in QlikView before export. 

Labels (2)
1 Solution

Accepted Solutions
lockematthewp
Creator II
Creator II

When loading these values in the script, I would create another field called [Product Description]. Then you could be like:

Load [Product],

….,

if ([Product] = 'FXFORW', 'Forward',

if ([Product] = 'FXSPOT', 'Spot', …… )) as [Product Description],  

….

From ....

View solution in original post

2 Replies
lockematthewp
Creator II
Creator II

When loading these values in the script, I would create another field called [Product Description]. Then you could be like:

Load [Product],

….,

if ([Product] = 'FXFORW', 'Forward',

if ([Product] = 'FXSPOT', 'Spot', …… )) as [Product Description],  

….

From ....

acsaggar
Contributor II
Contributor II

You can use a straight table and simply add a placeholder expression like '0' or '1' and ignore that column. Straight tables should let you label your field names directly.

Alternatively you can alias each of the fields in the script but this will add unnecessary data.