5 Replies Latest reply: Aug 21, 2016 6:47 AM by Marco Wedel RSS

    How to use the function

    moona karbalaee hadi

      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