# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## Previous Quarter Growth

Hi,

i'm new to qliksense and i'm currently having trouble calculating previous quarter growth in a graph.

I'm using a Combo Chart, with the sales by quarter.

In the database i only have the quarter with the following format "2017 Q2".

How can i create the growth in the graph?

I was using this formula "(Sum(PerIodo)/sum({<PerIodo={"left(PerIodo,4)-1,' ',right(PerIodo,3))"}>}Quantia))-1" but it is not working.

I also read in the forums to use As-Of table but from what i was able to understand it needs to have the date (DD/MM/YYYY).

That information i don't have.
Can anybody give me a hand?

9 Replies
Valued Contributor

## Re: Previous Quarter Growth

if you have "date"  field

Try this in editor

Table:

.......,

Date,

Dual('Q' & Ceil(Month(Date)/3) & Year(Date), QuarterStart(Date)) as quart

FROM...............................

;

...

in the table or chart

sum({\$<quart={\$(=ONLY(quart)-1)}>} Sales)

Not applicable

## Re: Previous Quarter Growth

I haven't got any date field, hence the problem.

The only field i have is Quarter --> "2017 Q2"

Valued Contributor

## Re: Previous Quarter Growth

Check this out.

(Pls ignore the two variables, I am not using them at all. They are for helping another person, not for this case.)

Not applicable

## Re: Previous Quarter Growth

Hi Fei Xu,

From what i understood you loaded the information (sales and quarter) in the script.

The thing is my dataset has currently 173.111 lines ranging from 2015 Q1 to 2017 Q2.

Am i understanding correctly?

Also i wanted the Previous Year Growth and not previous period growth.

Esteemed Contributor

## Re: Previous Quarter Growth

I can't get where do you find this troubelsome?

You can just have your Qarter field as a dimension, and as a measure having 2 measures:

- sum(expression)

- (sum(expr)-above(sum(expr)))/ above(sum(expr)) and format it as % (secondary axis)

You'll have your graphic as follow:

see the attached app !

Not applicable

## Re: Previous Quarter Growth

Hi Omar thanks for the reply,

but i don't want Previous period growth but previous year growth.

I want to have (2017 Q2 / 2016 Q2) -1 (PYG)

Is it possible?

New Contributor II

## Re: Previous Quarter Growth

I am not sure if this is the result that you were looking for? Comparing previous year by quarter?

Not applicable

Hi Jason,