topic create functions inside the script editor in QlikView

create functions inside the script editor

ali_hijazi — Fri, 24 Jun 2011 13:28:47 GMT

Hello

is there a possibility to create a function inside our script and use this function in our load statements?

I mean I want to create a function that takes a numeric parameter and returns a valid DateTime

actually now I'm writing the following

case lendth(trim(char(csdate))) ,.....

where csDate is supposed to be a date value in the client's database but is actually saved as integer as follows:

3231 this means it is 23 of january 2003!!

so what I want is wite a function to convert this integer value into a valid datetime value

this technic of saving dates as integer is existing in several tables

create functions inside the script editor

Fri, 24 Jun 2011 14:08:16 GMT

You can write a macro function and do it that way (control + m). As far as your actual example goes I don't actually know how to write it but if you just write it in a macro you can use it as a function in your script very easily.

create functions inside the script editor

Anonymous — Fri, 24 Jun 2011 14:46:15 GMT

You wouldn't need a custom function for this, but it would be helpful with a better explanation of the format used.

In your example it looks like they use YDDM, so what is the number for a date like 1999-12-31? 993112?

create functions inside the script editor

ali_hijazi — Fri, 24 Jun 2011 17:35:23 GMT

yes this is the format

create functions inside the script editor

kaushiknsolanki — Fri, 24 Jun 2011 18:35:47 GMT

Hi,

Try below function.

Sub abc(Number)

call = date(date#(Number,'YDDM'),'YY-DD-MM')

End sub

load

'$(call)' as date

AutoGenerate 1;

Regards,

Kaushik solanki