5 Replies Latest reply: Jul 1, 2013 4:19 AM by Tomas Hylander RSS

    mapping the string 'jan' as a month?

    Tomas Hylander

      I have a excel-file with a cell containing the month in text, but I cant get Qlikview to understand that it is a month.

       

      Tried converting it manually to number and then makedate() but wasnt able to make it work.

       

            
      If(månad = 'Jan',01,
      
            If(månad = 'Feb',02,
      
            If(månad = 'Mar',03,
      
            If(månad = 'apr',04,
      
            If(månad = 'maj',05,
      
            If(månad = 'Jun',06,
      
            If(månad = 'Jul',07,
      
            If(månad = 'aug',08,
      
            If(månad = 'Sep',09,
      
            If(månad = 'Okt',10,
      
            If(månad = 'Nov',11,
      
            If(månad = 'Dec',12
      
            ,0)))))))))))) AS månadsNummer, 
      
      
      

       

      and the made a new load with resident on the precious table

       

      tmpMonth:
      Load
       month(makedate(År_Temp,månadsNummer) ) as månad_Temp
      resident Invent;
      
      
      

       

      Must be doing something wrong or in need of diffrent solution..

       

      Thanks in advance.