How to create a StackBar grafic from a Table with unique index ?

[#1]

Hi Community, I´m a beginner from this tool and I need to create a StackBar grafic like this

from a table like this

The problem for me is that I can't get the SUM values from the field "Graf1_Monto" I think the field "Indice" don´t let me get then SUM value from field "Graf1_Monto". But the problem has this contidion:

I must use only this table and no other table.

I really appreciate all your help!

Note : added my qvw file

Mensaje editado por: Ivan Parraga

[Gysbert_Wassenaar]

I don't see any reason why you can't create that chart using data from that table. Use Graf1_Ano as first dimension, Graf1_Estado as second dimension and sum(Graf1_Monto) as expression. Make sure to use the exact case-sensitive field names. You can change the chart from grouped columns to stacked columns on the Style tab.

[maxgro]

try with

2 dimensions (Graf1_ano, Graf1_estado)

and an expression (sum(Graf1_monto)),

before in a straight table (what do you get?) and then change to a bar chart

[#4]

Hi Gysbert

When i try to do the chart, ussing Graf1_Ano as first dimension, Graf1_Estado as second dimension and sum(Graf1_Monto) as expression , the chart looks like that

Originaly my table was only 3 field (Graf1_Ano,Graf1_Estado,Graf1_Monto), and then i did the chart as the same way you say , and with this structure the chart wasnt a problem , but when added the field "Indice"  the chart changed. ( Excuse me for my bad english)

[Gysbert_Wassenaar]

You can change the chart from grouped columns to stacked columns on the Style tab

Have you tried that already?

but when added the field "Indice"  the chart changed

But why do you want the field Indice?

[#6]

Hi , Gysbert

!

Yes, the chart is always setting in staked colums. that is not the solution.

In my qvw file  The tab "Chart1" contains a chart from a table with 4 fieds (Graf1_Ano ,Graf1_Estado, Graf1_Monto, indice) , the tab "Chart2" contains a chart from a table with 3 fieds (Graf1_Ano ,Graf1_Estado, Graf1_Monto), in this case do the chart is very easy for me. But I need to do that with the 4 fields table.

[#7]

Hi Massimo ,

Do you have an example with a table with similar structure ?

[#8]

I must use the field Indice in my table, because the fields Graf1_Ano ,Graf1_Estado and Graf1_Monto are INPUTFIELD type and i need a field that identify all rows

[#9]

Hi Gysbert

I added the qvw file for best understand about my question.

thks