3 Replies Latest reply: Jun 22, 2011 8:20 AM by mpsaei1205 RSS

    Problem With Char Data

      Hi Gurus,

       

      I´m having a litlle problem to show in my Chart the budget, let mi explain the case:

       

      1.- I have a Excel file with Budget amount.

       

           T$CITG$O   T$ITEM$O      Jan     Feb     Mar

       

           XXXX          YYYY          1500     1200     500

       

      I make a "Cross table" with this sentence

       

      crosstable(Mes, Cantidad, 2)

      load T$CITG$O,

      T$ITEM$O,

      [1],

      [2],

      [3],

      [4],

      [5],

      [6],

      [7],

      [8],

      [9],

      [10],

      [11],

      [12]

       

       

       

      But when I want to show in my Chart    the Qty of Monthly Budget, nothing happen.

       

      How I can show it? Please could somebody help me.

        • Re: Problem With Char Data
          Kaushik Solanki

          Hi,

           

             When you load this you will have 4 fields,  T$CITG$O   T$ITEM$O,Mes, Cantidad.

           

             How all you have to do is create a chart. give expression as month(Mes) and expression as sum(Cantidad).

           

           

             Hope this will solve your problem.

           

          Regards,

          Kaushik Solanki

          • Re: Problem With Char Data

            Cannot Understand your Cross Table Query, The data which you have posted here dont have [1],[2]...[12]

             

            From Where did you get these numbers? Is this 1 to 12 are months?

             

            Your cross table query should be as follow.

             

            CrossTable(Month, Data, 2)

            LOAD T$CITG$O,

                 T$ITEM$O,

                 Jan,

                 Feb,

                 Mar

            FROM

            \\test.txt

            (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

             

             

            Instead of say al the fields at Load, you may also say Load * from Table name.

             

            Check out the attached Application.

             

            - Sridhar

              • Re: Problem With Char Data

                Thanks for your response,

                You are right, is [1],[2],..... to [12] and it´s a month, I´m using a free version of QVW, so I can´t see the atache File.

                 

                In other hand I´m trying to compare Budget vs. Sales ( It is in my ERP application), let me test with your sugestion a I let you know.