Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Calculating Time Series Growth %

I am trying to calculate QoQ growth % of sales through time and plot it in a manner similar to the chart below. I'm not sure if there is a way to do this through set analysis (all of my attempts have failed). I am able to calculate QoQ growth but only one period at a time

(sum({$<[Time Period]={"12-2015"}>}[Sales])-sum({$<[Time Period]={"09-2015"}>}[Sales]))/(sum({$<[Time Period]={"09-2015"}>}[Sales]))

.I've also tried  Not sure if it matters but each time period has ~2000 entries. Is there anyway to do this? Any help would be appreciated! Thanks in advance!

qlikcommTS.JPG

1 Solution

Accepted Solutions
MVP
MVP

Re: Calculating Time Series Growth %

Try something like this:

=(Sum(Sales) - Above(Sum(Sales)))/Above(Sum(Sales))

3 Replies
MVP
MVP

Re: Calculating Time Series Growth %

Try something like this:

=(Sum(Sales) - Above(Sum(Sales)))/Above(Sum(Sales))

MVP
MVP

Re: Calculating Time Series Growth %

May be as attached:

Capture.PNG

Not applicable

Re: Calculating Time Series Growth %

Much simpler than I thought. Thank you!

Community Browser