topic Re: How to create a StackBar grafic from a Table with unique index ? in QlikView

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

Wed, 24 Jun 2015 15:30:30 GMT

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

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

Gysbert_Wassenaar — Wed, 24 Jun 2015 16:03:43 GMT

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.

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

maxgro — Wed, 24 Jun 2015 16:05:09 GMT

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

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

Wed, 24 Jun 2015 17:36:35 GMT

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)

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

Gysbert_Wassenaar — Wed, 24 Jun 2015 17:39:26 GMT

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?

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

Wed, 24 Jun 2015 18:23:32 GMT

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.

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

Wed, 24 Jun 2015 18:26:57 GMT

Hi Massimo ,

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

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

Wed, 24 Jun 2015 18:36:36 GMT

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

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

Wed, 24 Jun 2015 20:38:38 GMT

Hi Gysbert

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

thks