Discussion board where members can get started with QlikView.
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)
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.
Go to Solution.
Thanks for your response,
You are right, is ,,..... to  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.
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.
Cannot Understand your Cross Table Query, The data which you have posted here dont have ,...
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)
(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.