2 Replies Latest reply: Apr 15, 2013 11:05 AM by Israr Khan RSS

    Cross Table Function.

    Israr Khan

      Hi Community,

      i have a simple question about CrossTable() function.

       

      i have excel file starting. JAN, FEB MAR, APR.

       

      if i am using crosstable(Month, Data), starting from 1, default is 1.

      if i am using crosstable(Month, Data,1), it start from FEB, Showing Jan as a SEPRATES Field,

      if i am using crosstable(Month, Data,0), IT DOES NOT WORK.

       

       

      How to read the Jan column..

       

       

      Regards

       

      Khan

        • Re: Cross Table Function.
          Henric Cronström

          With the crosstable prefix, you always need a key that links the values of the different data columns. Otherwise QlikView will not be able to track which initial row the value belongs to. In your case you do not have such a key, so you need to create one.

           

          Try

           

          Crosstable (Month, Data)

          Load

               recno() as Key,

               Jan,

               Feb, ...

           

          HIC

            • Re: Cross Table Function.
              Israr Khan

              Thank you so much..

              its working..

               

              But if,

              for example i have 10 coulmns, and i want to use crosstable 1 to 5, and others 5 i want to load as it is.

              so how can we control the right side.

               

              eg, 2005, 2006,2007,2008,2009, SALESREP, REGION. SO ON.

               

              Kind Regards

               

              Khan.