Qlik Community

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?

Thanks in advance.

1 Solution

Accepted Solutions
brenner_martina
Valued Contributor II

Re: Renaming fields in an Inline statment

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

4 Replies
giakoum
Honored Contributor II

Re: Renaming fields in an Inline statment

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.

brenner_martina
Valued Contributor II

Re: Renaming fields in an Inline statment

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

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

Community Browser