topic Re: How to use the function in QlikView

How to use the function

Tue, 16 Aug 2016 14:36:39 GMT

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

Re: How to use the function

miguelbraga — Tue, 16 Aug 2016 16:18:22 GMT

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,

Re: How to use the function

Sat, 20 Aug 2016 09:22:15 GMT

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

Re: How to use the function

Sat, 20 Aug 2016 09:22:34 GMT

Why you have not used the function؟

Re: How to use the function

rwunderlich — Sat, 20 Aug 2016 23:33:52 GMT

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

-Rob

Re: How to use the function

MarcoWedel — Sun, 21 Aug 2016 10:45:23 GMT

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