topic Re: Using the MonthEnd function in a script in QlikView

Using the MonthEnd function in a script

Anonymous — Fri, 10 Jul 2015 17:32:34 GMT

I can use the MonthEnd function just fine as a calculated dimension, but when I try to use it in a script I get an error that says the function is undefined. Here is the code in the script that is getting the error:

SQL SELECT *,

MonthEnd([Payment Date]) AS PymtMth

FROM tblPayments;

The script connects to an Access database in which there is a table called tblPayments containing a field called Payment Date. Any help would be appreciated.

Re: Using the MonthEnd function in a script

sunny_talwar — Fri, 10 Jul 2015 17:45:44 GMT

Try this:

LOAD *,

MonthEnd([Payment Date]) AS PymtMth;

SQL SELECT *

FROM tblPayments;

The reason might be because the SQL may not have MonthEnd (not an expert in SQL, so don't really know). but QlikView has it so you can use it in the preceding load.

HTH

Best,

Sunny

Re: Using the MonthEnd function in a script

MK_QSL — Fri, 10 Jul 2015 17:47:59 GMT

it should work as per sunindia reply (preceding load)

only remove , after SELECT *

LOAD *,

MonthEnd([Payment Date]) AS PymtMth;

SQL SELECT *

FROM tblPayments;

Re: Using the MonthEnd function in a script

sunny_talwar — Fri, 10 Jul 2015 17:49:01 GMT

Good eye, thanks for catching that, I made the update .

Re: Using the MonthEnd function in a script

Anonymous — Fri, 10 Jul 2015 17:55:10 GMT

That did it! Thanks very much.