topic QOQ growth in QlikView

QOQ growth

chinnuchinni — Sat, 16 Nov 2024 04:00:06 GMT

Hi All,

I am plotting some data which are quarterly, like Q1'15, Q2.15, Q3'15,....................., Q1'16, Q2'16, Q3'16,....... and so on. For Q3'16 growth should be value of Q3'16 - Q3'15.

Please help on this .

Regards

Re: QOQ growth

jyothish8807 — Mon, 01 Apr 2019 06:19:52 GMT

Hi Chinnu,

Are you generating the Q fields from a date field ? Or is it provided as it is in the source ?

A sample data will be helpful

Re: QOQ growth

chinnuchinni — Mon, 01 Apr 2019 06:41:09 GMT

Hi Jyothish,

Thank you for Quick response.

please find below for sample data.

Regards

Re: QOQ growth

chinnuchinni — Mon, 01 Apr 2019 06:43:46 GMT

Re: QOQ growth

jyothish8807 — Mon, 01 Apr 2019 07:05:02 GMT

Hi Chinnu,

Try this:

Re: QOQ growth

chinnuchinni — Mon, 01 Apr 2019 07:16:59 GMT

Thank you.

I need YOY in the same table.

Is it possible in the pivot table ?

Re: QOQ growth

chinnuchinni — Mon, 01 Apr 2019 07:38:18 GMT

say example,

if we take year and quarter as dimension and sum(sales )as dimension.

If we expand year it will show 4 quarters Q1,Q2,Q3,Q4 sales for based on year wise.

I need to find same as previous year Q1,Q2,Q3,Q4,

if I will get this, I can easily find it out.

Regards

Re: QOQ growth

jyothish8807 — Mon, 01 Apr 2019 07:43:55 GMT

Hi Chinnu,

Try this:

Re: QOQ growth

chinnuchinni — Mon, 01 Apr 2019 09:55:44 GMT

it's giving wrong YOY.

yoy should give.....

(2018(Sales) - 2017(Sales)) /2017(Sales)

Re: QOQ growth

jyothish8807 — Mon, 01 Apr 2019 11:11:18 GMT

Hi Chinnu,

I am not exactly clear on your requirement.

See this:

Re: QOQ growth

chinnuchinni — Mon, 01 Apr 2019 11:25:12 GMT

I need to show country wise QOQ & YOY in pivot table.

Dimensions are Country, Year, Quarter.

logic:

QOQ = > 2018Q1 growth = 2018Q1-2017Q1 /2017Q1

2018Q2 growth = 2018Q2-2017Q2 /2017Q2

..................so on

YOY = > 2018 growth = 2018-2017 /2017

................................so on

so by seeing pivot table it should show growth rate of both QOQ & YOY.

I hope it's now clear.