topic Re: HELP WITH BAR GRAPH in QlikView

HELP WITH BAR GRAPH

paulosrl — Sun, 12 Mar 2017 04:06:15 GMT

Hi all,

I need a bar graph that show total of NATUREZA_LANCAMENTO in one bar and a second bar a value choice in the list DESCRICAO_LANCAMENTO.

I have other issue, my graph has two dimensions (YEAR X MONTH), when a click in YEAR i cant put the month name i x-line.

The project and the data are attached here.

Thanks for help.

The grahp tha i need is something like the picture.

The blue bar is sum of NATUREZA_LANCAMENTO = 'C'

The red bar is sum of choice in the list DESCRICAO_LANCAMENTO like for exemple 'LANCAMENTO 1'

The fix bar will be ever => sum of NATUREZA_LANCAMENTO = 'C', the dinamic bar will be the choice in the list DESCRICAO_LANCAMENTO. 🙂

Thanks for help!!!

Re: HELP WITH BAR GRAPH

vishsaggi — Sun, 12 Mar 2017 04:43:21 GMT

May be this? Check the expressions? Will they be Sum or Count? Change accordingly.

Re: HELP WITH BAR GRAPH

paulosrl — Sun, 12 Mar 2017 06:53:40 GMT

Hi Vishwarath, almost perfect, I've made some modifications, to use a Dinamic List for draw the graph, but, isnt ok.

I was using:

Sum({< DESCRICAO_LANCAMENTO = {'LANCAMENTO 1'}, NATUREZA_LANCAMENTO= {'C'}>} VALOR_TRANSACAO)

To get a static value

I'm trying made a dinamic select using list with the field <DESCRICAO_LANCAMENTO>

I'm trying this, but the graph doesnt show de select value on list:

Sum({< DESCRICAO_LANCAMENTO = {$(=selecaoGrafico)}, NATUREZA_LANCAMENTO= {'C'}>} VALOR_TRANSACAO)

This is my only issue now...

Thanks

The new version is attached..

Re: HELP WITH BAR GRAPH

vishsaggi — Sun, 12 Mar 2017 17:59:58 GMT

When you select Month and Year what the values to be displayed in your bar graph for Blue bar and Red bar for one selection LACAMENTO 1?

Can you give me what figures should be plotted for Blue bar and Red bar? Cos for me both are coming as same value.

Re: HELP WITH BAR GRAPH

vishsaggi — Sun, 12 Mar 2017 18:08:08 GMT

Check this attached ? You dont need any specific variable to get current selections i believe here? Let me know if this is what you are looking for ?

Re: HELP WITH BAR GRAPH

paulosrl — Sun, 12 Mar 2017 19:46:23 GMT

Hi Vishwarath,

The qvw doesnt work yet,

Let me show you what I Need:

When I use the expressions in the picture:

and

The result is correct, like the screens, for 2013, 2014 and 2015:

2013

2014

2015

Your last version, doesnt calcute the correct values. The correct values are on the screens (2013, 2014 and 2015) .

If I try use set analysis to calculate dinamic, based on selected value on list box, like as: LANCAMENTO1, 2,3, ...

The graph doesnt show the red column (Lancamento Escolhido)

This is the main problem. I've tryed a lot of test using set analysis, but nothing is fix the problem..

😞

Thanks again.

I've attached the Version 3 of qvw.

Re: HELP WITH BAR GRAPH

vishsaggi — Mon, 13 Mar 2017 01:47:55 GMT

Use this two expressions. And the red will display only when you select a value in DESCRICAO field.

Dim: MES&'-'&ANO

expr1: Sum({< NATUREZA_LANCAMENTO = {'C'}, DESCRICAO_LANCAMENTO = >} VALOR_TRANSACAO)

expr2:

= Sum({< DESCRICAO_LANCAMENTO = {'$(=GetFieldSelections(DESCRICAO_LANCAMENTO))'}, NATUREZA_LANCAMENTO = {'C'} >} VALOR_TRANSACAO)

Re: HELP WITH BAR GRAPH

paulosrl — Mon, 13 Mar 2017 02:05:12 GMT

It's works!!! Thanks guy!!!! I will test in hard mode now !!!!

Thanks!!!