Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Graphic with Specific Period

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

Grafico_Qlik.JPG

Grafico_Excel.JPG

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.

5 Replies
jolivares
Specialist
Specialist

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

Capture.PNG

Not applicable
Author

No,

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

jonas_rezende
Specialist
Specialist

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!

Not applicable
Author

Hi, Thanks to answer!

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

jonas_rezende
Specialist
Specialist

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!