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: 
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?

Thanks in advance.

1 Solution

Accepted Solutions
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

the easiest way to do this even with entering functions:

Data:
LOAD Customername As Customer,
  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

View solution in original post

4 Replies
giakoum
Partner - Master II
Partner - Master II

Hope this helps

Not applicable
Author

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.

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

the easiest way to do this even with entering functions:

Data:
LOAD Customername As Customer,
  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
Author

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