Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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
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.