2 Replies Latest reply: Nov 7, 2016 11:39 PM by Satya Walpresa RSS

    TimeStamp Column converted to General

    Satya Walpresa

      Hi,

       

      i have encountered a problem using qliksense using Oracle 11g as my datasource. i have this data mart consisted of mostly Timestamp columns. somehow when i use data manager to load the data, qliksense recognize my Timestamp Columns as general and all of them converted to Number. any of you guys have encounterd the same problem? how is the way around for that because i have around 80 Columns and its quite a job to use timestamp function for all of the column one by one hehe.

       

      thank you

        • Re: TimeStamp Column converted to General
          Gysbert Wassenaar

          Well, timestamp values are actually just numbers. By marking a field as a Timestamp field you give a hint to Qlik Sense to treat the field as a timestamp instead of just a number. So it will apply the default timestamp format to it for you. I'm afraid that Qlik Sense isn't smarter than that at the moment. So, yes, you'll have to change the setting for each field from General to Timestamp yourself. Or just leave them as they are and do the formatting in the front end chart objects.