topic Re: Functions On Inline Tables in QlikView

Functions On Inline Tables

pgalvezt — Wed, 07 Nov 2012 20:03:13 GMT

Hi, How can I use fuctions on Tables done with Inline Functions?

For example In my script I have:

MonthName(Date(Fecha1,'YY-MMM')) as Fecha1,

I have this but QV gives Error:

Report:

Load *, MonthName(Date(Fecha1,'YY-MMM')) as Fecha1;

Load * Inline[

Fecha1, Fecha2

31/01/2011, 30/11/2010

31/01/2011, 31/12/2010

31/01/2011, 31/01/2011

28/02/2011, 31/12/2010

28/02/2011, 31/01/2011

Thank You!

Re: Functions On Inline Tables

cesaraccardi — Wed, 07 Nov 2012 20:09:23 GMT

Hi,

Do like this:

Report:

Load *, MonthName(Date(Fecha1,'YY-MMM')) as Fecha1_AnoMes

Inline[

Fecha1, Fecha2

31/01/2011, 30/11/2010

31/01/2011, 31/12/2010

31/01/2011, 31/01/2011

28/02/2011, 31/12/2010

28/02/2011, 31/01/2011

Regards,

Cesar Accardi

Re: Functions On Inline Tables

MayilVahanan — Wed, 07 Nov 2012 20:17:13 GMT

Try this also

Load *,MonthName(Date(Date,'YY-MMM')) as MonthName;

Load *,Date#(Fecha1,'DD/MM/YYYY')as Date Inline

[

Fecha1,Fecha2

31/01/2011,30/11/2010

31/01/2011,31/12/2010

31/01/2011,31/01/2011

28/02/2011,31/12/2010

28/02/2011,31/01/2011

];

Re: Functions On Inline Tables

CELAMBARASAN — Wed, 07 Nov 2012 22:19:24 GMT

Hi,

In your load statement you have used * (asterisk) which is to include all the fields.

Example:

Your inline load has Fecha1,Fecha2 fields.

You are trying to create another field in the name of Fecha1 again along with it.

There should not be more than one with same name. Not alone QV none accepts this.

Hope your clear about the error.