topic Re: Problem With Char Data in QlikView

Problem With Char Data

Wed, 22 Jun 2011 10:33:01 GMT

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

kaushiknsolanki — Wed, 22 Jun 2011 10:59:58 GMT

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

Wed, 22 Jun 2011 12:02:16 GMT

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

Wed, 22 Jun 2011 12:20:40 GMT

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.