topic Re: quarter over quarter in QlikView

quarter over quarter

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

Steve Dark

hic

felipedl‌

youssef belloum

i want to calculate the QoQ and YoY like below attached screen shot in pivot table.

and the data is attached it is coming from db directly.

how can i do this?

Re: quarter over quarter

simospa — Wed, 19 Sep 2018 09:54:47 GMT

Sony,

the comparison must be implemented betewen the current year and the previous or between a selected year and the previous of the selected?

For the Y/Y field you could use something like this (in the load script I extracted the YEAR from the quarter)

(Sum({<Year = {'$(=Max(Year))'}>} [Value])-Sum({<Year = {'$(=Max(Year)-1)'}>} [Value]))/Sum({<Year = {'$(=Max(Year)-1)'}>} [Value]))

that compare the year selected and the previous, if you want to compare the current and the previous you have to replace Max(Year) with Year(Today()).

For the Q/Q the formula is similar but more info are needed: what do you want to compare? This quarter with the previous? A selected quarter with the previous?

If with the current, you need to create a variable in the script.

LET vThisQuarter = 'Q' & ceil(month(Today())/3);

and then use it in the set analysis.

But I think that more information are needed (about the totals in the png too).

kind regards,

Re: quarter over quarter

soniasweety — Wed, 19 Sep 2018 10:04:45 GMT

for Y/Y - for the selected year should be same for previous year

for Q/Q - for example

so if Sep 27 is week no 39 for the year and week no 9 for the quarter, it has to be compared with week no 39 of previous year and week no 9 for the prev quarter

for QOQ how can i include this in set LET vThisQuarter = 'Q' & ceil(month(Today())/3);?

Re: quarter over quarter

soniasweety — Wed, 19 Sep 2018 12:19:17 GMT

Hi Frank Hartmann any solution for this?

Re: quarter over quarter

felipedl — Wed, 19 Sep 2018 13:50:12 GMT

Hi Sony,

See the attached QVW for a solution.

Felip.

Re: quarter over quarter

soniasweety — Wed, 19 Sep 2018 13:56:48 GMT

thank you so much sir

. i m checking on this --

one doubt QoQ and YoY the values is showing more than 100% like 209% 430% like that... is that correct?

Re: quarter over quarter

felipedl — Wed, 19 Sep 2018 14:02:41 GMT

Thats dependant on the data you have on the spreadsheet.

As i've seen, your data is having that data and gives the correct value:

see the following:

Check the file to see if the values are correct and once they're ok, the app will show the appropriate data.

Re: quarter over quarter

soniasweety — Wed, 19 Sep 2018 14:11:28 GMT

thanks for the clarification..

i have attached the updated qvw.. in this i have implemented document on open trigger

it should select the current quarter and next 3 quarters.

means 2018Q3 current quarter

2018Q3

2019Q1

2019Q2

2019Q3 this is one table

and one more table with same QoQ and YoY --

it should having the selection for

2018Q3

2019Q1

2019Q2

2019Q3 and above 2019Q3 ,2019Q4 ,2020Q1.... so on how can i include this in other table?

Re: quarter over quarter

soniasweety — Wed, 19 Sep 2018 14:14:08 GMT

like this for example

Felip Drechsler

beyond means above 2019Q3........all future quarters

Re: quarter over quarter

felipedl — Wed, 19 Sep 2018 16:11:52 GMT

What you could do is this:

Based on the selections, you get the values from the minimum value selected to all the quarters from that point on, and then limit the graph to 4 first values for fiscal period.

See the attached QVW.

Re: quarter over quarter

soniasweety — Wed, 19 Sep 2018 16:26:00 GMT

sorry for mis lead

i need the same table which was done by you.... its for 4quarters i.e current quarter and next 3 quarters

second table i need with

region ,type, Tcv Qoq Yoy -----------------this will consists by default 4qtrs and beyond 2019Q3

Re: quarter over quarter

felipedl — Wed, 19 Sep 2018 17:25:05 GMT

Hi Sony,

Modified the graph but didnt understand the second graph explanation.

Maybe you can try and get it from the info and graphs that are already in the app an create the visualization you need.

Re: quarter over quarter

soniasweety — Thu, 20 Sep 2018 09:54:47 GMT

thanks for your inputs sir felipedl

Re: quarter over quarter

felipedl — Wed, 14 Nov 2018 18:45:20 GMT

Glad it helped :).