Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

quarter over quarter

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?

1 Solution

Accepted Solutions
felipedl
Partner - Specialist III
Partner - Specialist III

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.

View solution in original post

13 Replies
simospa
Partner - Specialist
Partner - Specialist

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,

S.

soniasweety
Master
Master
Author

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);?

soniasweety
Master
Master
Author

Hi Frank Hartmann   any solution for this?

felipedl
Partner - Specialist III
Partner - Specialist III

Hi Sony,

See the attached QVW for a solution.


Felip.

soniasweety
Master
Master
Author

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?

felipedl
Partner - Specialist III
Partner - Specialist III

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:

sample.png

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

soniasweety
Master
Master
Author

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?

soniasweety
Master
Master
Author

like this for example

Felip Drechsler

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

beyond.PNG

felipedl
Partner - Specialist III
Partner - Specialist III

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.