topic Re: Renaming fields in an Inline statment in QlikView

Renaming fields in an Inline statment

Thu, 26 Jul 2012 12:37:28 GMT

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.

Re: Renaming fields in an Inline statment

giakoum — Thu, 26 Jul 2012 12:47:26 GMT

Hope this helps

Re: Renaming fields in an Inline statment

Thu, 26 Jul 2012 13:13:59 GMT

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.

Re: Renaming fields in an Inline statment

brenner_martina — Thu, 26 Jul 2012 13:18:22 GMT

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

Re: Renaming fields in an Inline statment

Thu, 26 Jul 2012 13:55:54 GMT

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