7 Replies Latest reply: May 9, 2018 7:46 AM by Mohammed Al Radi RSS

    Why is Qlik Reading a number as a date? How can I change that?

    Mohammed Al Radi

      Dear Qlik Community,


      I hope this finds you well. After crosstabling the script below the date field works but the 'scoremath' field produces a mixture of 'dates' and numbers. I checked the data source and all numbers in 'scoremath' are numbers less than 1 (0.2,0.6 etc...). There are no dates, but Qlik reads it that way (e.x. 12/30/1899). Is there anything I can do in the script to make Qlik treat the values as numbers? I tried num(scoremath) but that did not work either. Thank you for your support



      [weekly quizzes pre school math]:

      Crosstable ([Date], [scoremath],4)


      [الرقم التسلسلي] AS [preschool.الرقم التسلسلي],

      [الاسم] AS [preschool.الاسم],

      'weekly quizes prescohol' as flagpreschool,

      حساب as [preschool-رياضيات],












      FROM [lib://MM (trial-qlik-01_qliksupport)/Pre-school Assessments (5).xlsx]

      (ooxml, embedded labels, table is [weekly quizzes]);


      [Date weekly quiz]



      [preschool.الرقم التسلسلي],

      'Math' as subjectflag,

      'preschool' & '+' & [preschool.الاسم] as Key,


      Date#(Date) as finaldate,



      Resident [weekly quizzes pre school math];

      Drop table [weekly quizzes pre school math];