5 Replies Latest reply: Apr 24, 2014 10:38 AM by Jose Chu RSS

    Make Column as Month

      Hi all,

       

      I am currently importing an excel file with the following format,

       

      I would like to know if there is a way to make Qlikview consider the whole column as the month represented.

       

      Account Number

      Jan Forecast

      Feb ForecastMar ForecastApril Forecast
      May ForecastJun Forecast
      12837124$18293$23523$21342$32452$33252$34231
      34580933$92083$23523$23523$32563$33553$24325
      38902490$90832$43653$23523$54457$56432$66431
      19283233$23523$45633$34747$33569$45644$57743
      39284912$23552$34634$34534$34643$35324$56721

       

      Thank you very much in advance.

       

      Regards