How to use the function

[#1]

hi

The sql database function that gives me the correct output but not loaded at the Qlikview

Maybe I'm wrong format function is....
Please advise friends .

sample:

LOAD gender,

"profile_id",

    registeredAt;

SQL SELECT gender,

       registeredAt,

          "profile_id",

left([dbo].[datemtos](registeredAt),4) as sal

FROM "crs".dbo."extended";

//-------------------------------------------------------------------------------------

definitions used:

function name: datemtos

date field:registeredAt

database name:"crs"

Field of table: "extended"

*best regards*

moona

[miguelbraga]

Hey there,

Why not simply as this?

sample:

LOAD                gender,

                         "profile_id",

                         registeredAt,

                         left(registeredAt, 4) as sal;

SQL SELECT     gender,

                         registeredAt,

                         "profile_id"

FROM "crs".dbo."extended";

Hope this clarifies you

Regards,

MB

[#3]

Why you have not used the function؟؟؟؟؟

[#4]

Why you have not used the function؟

[rwunderlich]

Please explain what the function "datamos" does and we can suggest a QlikView equivalent.

-Rob

[MarcoWedel]

Your preceding load does not load the sal field.

Maybe just

SQL SELECT gender,

       registeredAt,

          "profile_id",

left([dbo].[datemtos](registeredAt),4) as sal

FROM "crs".dbo."extended";

Without preceding load

or adding sal in there

Regards

Marco