Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to use the function

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


5 Replies
miguelbraga
Valued Contributor III

Re: How to use the function

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

Not applicable

Re: How to use the function

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

Not applicable

Re: How to use the function

Why you have not used the function؟

Re: How to use the function

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

-Rob

Re: How to use the function

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

Community Browser