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:



      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!