Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kishoreravi1983
New Contributor

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