topic Graphic with Specific Period in QlikView

Graphic with Specific Period

Mon, 16 Nov 2015 12:02:03 GMT

Edit by Community Team member:

Please post topics in English unless in a language specific section.

Post translated with google translate.

---

Good day,

I'm trying to simulate an effect of Excel on Qlik and step by difficulties ...

I made a sequential graph demonstrates a month over the performance value and also the year, however, like to add a bar with an accumulated value of a given period.

I do not know if I was clear, I added the files to help

Caso alguém tenha passado por isso e possa ajudar, ficaria extremamente agradecido.

If someone has been through this I can help, I would be extremely grateful.

Re: Graphic with Specific Period

jolivares — Mon, 16 Nov 2015 18:52:19 GMT

If I understand, you need the table with your data... is that correct?

Re: Graphic with Specific Period

Mon, 16 Nov 2015 19:30:08 GMT

No,

I need plot a especific range in the graphich jul/15 - nov/15

Re: Graphic with Specific Period

jonas_rezende — Mon, 16 Nov 2015 19:34:08 GMT

Hi, Wallace Reis.

I hope have understood the your objective. So, was created one graph bar with value accumalation. See qvw attached.

The expressions were formed the RangeSum() and Above() functions.

P.S.: existem duas tabelas gráficas além da sua, elas estão com valores acumulados, sendo um gráfico de barras e uma tabela simples, a última como prova do valor acumulado.

Hope this helps!

Re: Graphic with Specific Period

Mon, 16 Nov 2015 19:43:20 GMT

Hi, Thanks to answer!

I need one more column in my graphic with the acumulate value between 01/07/2015 and 31/11/2015

Re: Graphic with Specific Period

jonas_rezende — Wed, 18 Nov 2015 12:49:17 GMT

Hi, Wallace Reis.

I created more two charts, one bar and other straight table, that contain accumulated between 01/07/2015 and 31/11/2015.

The base for calculate was created, now utilize how desired in your app.

Follow attached.

Hope this helps!