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: 
kishoreravi1983
Contributor III
Contributor III

Derive Corresponding Quarter from Previous Year.

Hi Friends,

Plz help me how to calcullate the below metrix.

 

Metrics to be derived
2017 -Q2 MAX Quarter Always
2016-Q2Quarter Corresponding to Max Quarter of Previous Year
2017-Q1Max Quarter - 1
Y/Y %2017Q2-2016Q2/2016Q2
Q/Q %2017Q2-2017Q1/2017Q1

Attached the Excel Sheet.

It would be of great help if some one can give me some pointers to it.

Regards,

Ravi

0 Replies