topic Growth in a line chart in QlikView

Growth in a line chart

mario-sarkis — Sat, 21 Feb 2015 10:10:18 GMT

Hey all,

I need to know how can i calculate the growth in a line chart in several time.

Example:

Suppose that we have this data:

Date. Data

Dec-12. 100

Dec-13. 150

Dec-14. 200

The groth that i need to show is :

Date. Growth

Dec-13. ((150-100)/2)*100

Dec-14. ((200-150)/2)*100

Ps:i have these three dates but in the growth formula i need to show on the line chart Dec-13 and Dec-14 only.

Thank you.

Gysbert_Wassenaar — Sat, 21 Feb 2015 10:36:51 GMT

See attached qvw.

mario-sarkis — Tue, 24 Feb 2015 14:14:07 GMT

hey Gysbert,

this cannot be apply when we have 2 dimension ?

i have the dimensions: Dates and a Group field

any other option ?

Thank you,

Gysbert_Wassenaar — Tue, 24 Feb 2015 20:31:16 GMT

Two dimension should work. Try adding the Group dimension to the chart. Or post a qlikview document that demonstrates your problem.