7 Replies Latest reply: May 17, 2011 3:26 AM by Jai Prakash RSS

    Crosstable Dates converted to string

      Hi everyone,

      I am trying to load data from an excel sheet into Qlikview but when the a crosstable is applied, it changes the date into a string and makes it useless

       

       

      This is an example of what I am doing. If anyone found a way to bring in date after applying crosstable, please Help!

       

                             |   11/01/10  | 11/02/10  | 11/03/10..........

      Project                    x                  y                z

      PBIT                    20000        300000       100000

       

      Crosstable applied

       

      Project       |   Date          |     PBIT

      X                  11/01/10    

                           11/02/10 

       

       

      Y                    11/01/10

                             11/02/10 

       

       

      Z                       11/01/10

                               11/02/10