Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Why you have not used the function؟؟؟؟؟
Why you have not used the function؟
Please explain what the function "datamos" does and we can suggest a QlikView equivalent.
-Rob
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