Problem With Char Data

[#1]

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.

[kaushiknsolanki]

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

[#3]

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

[#4 · Accepted solution]

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.