Growth in a line chart

[mario-sarkis]

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 · Accepted solution]

See attached qvw.

[mario-sarkis]

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]

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