7 Replies Latest reply: Aug 1, 2016 8:51 AM by Thirumala Dandamudi RSS

    Convert Hive TimeStamp in Date and Time at Qlikview

    Ant�nio Vilares

      Hi experts,
      following data set

       

      I've the following data set on Qlikview:

      erro2.PNG

       

      I'm trying to convert the Date_ID (that is a TimeStamp in Hive) in order to obtain the field Date and Time! I already try the Date# function but it still gives me this error:
      Error while compiling statement: FAILED: ParseException line 1:11 cannot recognize input near 'top' '10' 'Date' in selection target'. Qlikview

       

      How can I extract the Date and Time field from my Date_ID?

       

       

       

      Many thanks!