# 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!

1 Solution

Accepted Solutions
MVP

## Re: Calculating Time Series Growth %

Try something like this:

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

3 Replies
MVP

## Re: Calculating Time Series Growth %

Try something like this:

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

MVP

## Re: Calculating Time Series Growth %

May be as attached:

Not applicable

## Re: Calculating Time Series Growth %

Much simpler than I thought. Thank you!