# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

## Renaming fields in an Inline statment

Hi there guys.

I have created the attached dynamic table and I am interested in changing the name of the fields shown on the "choose a parameter" list box.

These fields are defined in the inline table called [_Dimension]. For some reason the "as" syntax doesn't work in the script

I have read some info about the mapping syntax but couldn't realize if its relevant for this case (and how does it work as well.. )

Can anyone give me a solution for that?

1 Solution

Accepted Solutions
Valued Contributor II

## Re: Renaming fields in an Inline statment

Hi,

the easiest way to do this even with entering functions:

Data:
Salesvalue As Sales,
OrderdateSales As Date,
Year(OrderdateSales) As Orderyear,
Month(OrderdateSales) As Ordermonth

INLINE [
Customername, Salesvalue, OrderdateSales
A, 120, 12.7.2012
B, 200, 2.5.2012
C, 250, 17.2.2012
];

Greetings from Munich

Martina

4 Replies
Honored Contributor II

Hope this helps

Not applicable

## Re: Renaming fields in an Inline statment

Thanks a lot Loannis for the quick reply..

Your solution did not answer fully to the problem since the new aliases did not affect the dynamic table, i. e., once choosing one of the new aliases you made, one could not see them reflecting on the dynamic table.

I need to see the fields I'm selecting in the dynamic table as well. prior to the name change it worked perfectly.

Valued Contributor II

## Re: Renaming fields in an Inline statment

Hi,

the easiest way to do this even with entering functions:

Data:
Salesvalue As Sales,
OrderdateSales As Date,
Year(OrderdateSales) As Orderyear,
Month(OrderdateSales) As Ordermonth

INLINE [
Customername, Salesvalue, OrderdateSales
A, 120, 12.7.2012
B, 200, 2.5.2012
C, 250, 17.2.2012
];

Greetings from Munich

Martina

Not applicable

## Re: Renaming fields in an Inline statment

Dear Dear Martina..

Your solution took me a while to sort, but once defined correctly, it made wonders.

so therefor I can define your solution as a "sehr gutte" one!

Vielen Dank!

Evya